Forum Discussion
Advocate Ihow 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/
Community ChampionWith 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/
Just to clarify, does something like this support being "published" up to powerbi.com to run as a service vs desktop mode?
I saw another post that broke out into many functions and someone said "you can't upload functions" (truncated).
TIA
- ImkeF
To my knowedge if it works in desktop with privacy settings on, it should also work in the service.
There are issues in the service with HTML-string and this article has good tips for it: http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
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.