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?
Best answer by amandapteodoro
Rafael11 wrote:
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.
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.
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.
