Dataflow - One or more tables references a dynamic data source

[VivienRossignon]

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

[Anonymous]

Legend!!! This blog saved my life

[VivienRossignon]

Thank you @ibarrau ! It works

[ibarrau · Accepted solution]

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-i...

https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request

I hope that helps,