Forum Discussion
Helper IWorkaround for "dynamic data source" not refreshing on Power BI Service
Hi pc2,
I could not find a workaround to this particular issue, where I had this problem I had to go to a simplified model in which I had to provide some pre-defined values to PBI. It just does not like complete random. In my case instead of using a text parameter as a Sharepoint address (kind of if A then Sharepoint.Files (textA) else Sharepoint.Files (textB) ) to define both connections separately and then use parameters to if.
In your case, I guess a workaround could be using something like
https://api.getdor.com/v2/location-metrics?datetime_start=2020-12-01T00%3A00%3A00&interval=hour;PAGE=201i.e. sending exact URL to the function instead of a generated based on the previous step (if you can predetermine it of course). In this case, you can generate a table of URLs first, add column calling the function for each URL and then combine the outputs.
Kind regards,
JB
Helper IHi Anonymous ,
Thank you so much for your input.
Unfortunately, the subsequent pages are not in page numbers (e.g. page2, page3,....). The next URL it provides is dynamic and there's no way I can know or guess it.
For example, the 2nd page URL would look like below:
"https://api.getdor.com/v2/location-metrics?next=eBZxqwoeiqew32fqew9ivovosijfewe23rfasldf"After the base URL, it uses "next=" to provide the pagination URL.