Forum Discussion
Dataflow - One or more tables references a dynamic data source
Hi all,
I tried to get data from Zendesk (Users) by using the rest api and pagination as we can retrieve only the first 1000 rows.
I created a parameter and a function to loop on each nextpage id but I get an error "One or more tables references a dynamic data source".
Here is the code
Remarks :
I'm using a PPU licence and the workspace is a premium one.
The same application works fine in PBI Desktop.
Any hints ?
Thanks
Hi. Sometimes the web urls can produce that error because it's not unique url. It's an url that will change depending on a parameter/entry/timeline/etc. That's why PowerBi can't understand the source and considers it as a dynamic source. In order to explain PowerBi that the URL is the same you need to use some parameters of the Web.Contents function. I'm talking about the first step of your code (the source with a json, it has that function inside). Check one of these posts out to understand the RelativePath and the Query parameters:
https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request
I hope that helps,
3 Replies
Hi. Sometimes the web urls can produce that error because it's not unique url. It's an url that will change depending on a parameter/entry/timeline/etc. That's why PowerBi can't understand the source and considers it as a dynamic source. In order to explain PowerBi that the URL is the same you need to use some parameters of the Web.Contents function. I'm talking about the first step of your code (the source with a json, it has that function inside). Check one of these posts out to understand the RelativePath and the Query parameters:
https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request
I hope that helps,
Thank you ibarrau ! It works
