Forum Discussion
Web.BrowserContents refresh issue on Power BI Service (dynamic data source)
Hi,
I have created a Power BI file that does web scrapping using the Web.BrowserContents function.
The scrapping is done dynamically, so I created a function for web scrapping and the parameters of this function are used to build my URL.
It works fine on Power BI Desktop, but I can't refresh the dataset on Power BI Service because I get the following error:
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.
The code looks like this:
(var_value as text) =>
let
Source = Web.BrowserContents("<base URL>?<parameter1>="& var_value ),
I saw that web.Contents allowed to avoid this error by using the Query parameter, but it doesn't seem possible with Web.BrowserContents.
Does anyone have a solution?
Thanks!
4 Replies
- lbendlinSuper User
- AnonymousNot applicable
Hi lbendlin ,
Thank you for your help.
However, I am not sure it is working. Am I not supposed to use this method to make an API call ? If yes, I'll get a binary output and not a HTML one.... no ?Thank you for your answers.
- lbendlinSuper User
Since you know that the returned data is actually the HTML you can parse it as such in your next step.