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.

[ScottWorld]

FYI: You can also have Airtable communicate with Power BI by using Make’s Microsoft Power BI integrations, along with Make’s Airtable integrations.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

- ScottWorld, Expert Airtable Consultant