Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not 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. 

      • lbendlin's avatar
        lbendlin
        Super User

        Since you know that the returned data is actually the HTML you can parse it as such in your next step.