Template M Query does not allow scheduling refresh in Power BI: Dynamic Data Source

[amandapteodoro]

The Template M Query provided by Airtable at this link which integrates Airtable with Power BI, does not allow scheduling refreshes in Power BI:

Instead of allowing you to schedule the refresh, Power BI shows this message warning that the "dataset includes a dynamic data source."

Previously, the other Template M Query, with the past API_KEY, allowed to schedule refreshes. Therefore, I think there has to be a way to ensure scheduling with the recent personal_access_token.

Has anyone had this problem as well? If so, does anyone know how to change the template to make it work?

[Rafael]

I've been facing the same issue. I don't have the solution yet, but as I could see, the root cause of the problem is regarding the fact that the part of the API script is dynamic. It's the case with the "Web.Contents" parameter that receives the "offset" variable but the script has to search for all the "offset" variable represents in the API. The solution is to transform this parameter, because it can't be dynamic.

This article says something about this problema

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

[amandapteodoro · Accepted solution]

Hi @Rafael! 

I contacted Airtable via GitHub and they promptly changed the code to allow scheduling automatic refresh.

Also, I saw that they recently updated the airtable's own link with the new code: https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query

It worked for me! 

[Rafael]

@amandapteodoro thank you very much. It's working now. You have been very kind to help.