Help

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

Topic Labels: API Custom Extensions
Solved
Jump to Solution
2204 3
cancel
Showing results for 
Search instead for 
Did you mean: 
amandapteodoro
5 - Automation Enthusiast
5 - Automation Enthusiast

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

amandapteodoro_0-1678912663599.png

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?

1 Solution

Accepted Solutions
amandapteodoro
5 - Automation Enthusiast
5 - Automation Enthusiast

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! 

See Solution in Thread

3 Replies 3
Rafael
4 - Data Explorer
4 - Data Explorer

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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! 

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