Forum Discussion
how to create a query that paginates?
With List.Generate you should be able to "harvest" the list of URL's - you can even try to "harvest" the content at the same time. (But watch out: There's an error in the documentation: Result of last example should be {2, 4, 6, 8})
See Chris' article on how List.Generate works in general: http://blog.crossjoin.co.uk/2014/06/25/using-list-generate-to-make-multiple-replacements-of-words-in-text-in-power-query/
Ok, So I went and setup a Get JSON data source and it works in Power BI desktop but when I publish it I see;
Dataset - had error. Unable to refresh the model because it references an unsupported data source.
Then I found the help page about data refresh here https://docs.microsoft.com/en-us/power-bi/refresh-data#what-can-be-refreshed and it says:
Note
If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.
So apparently this doesn't work, I need a gateway. I'm trying to publish this for other users outside my org and I can't ask them to install a gateway.