Forum Discussion

SorenHElisa's avatar
SorenHElisa
Helper I
3 years ago
Solved

Web page as datasource automatic refresh error The module named 'Html' has been disabled...

Hi,   PBIRS problem: User wanted to use a web page as source for their report. Web page do not require any authentication. Desktop working fine and reloads the data. Report server's automatic data...
PBIRS
refresh data
Web connector
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    Hi SorenHElisa ,

     

    Power BI Report Server has a limitation when using web data: only data files from web can be refreshed. Data based on Page or By example aren't refreshable. This limitation is because the M expressions created with Web.BrowserContents and Web.Page can't be refreshed. Power BI Report Server can only refresh Web.Contents data sources.

    For more details, you can read below:

    Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pabeader's avatar
pabeader
Post Patron
2 years ago

Here is an actual solution to this issue.  

 

Open Power BI Desktop.  Use that to make the initial connection to the WEB data you are trying to refresh.

Once you have a usable table of the data you are trying to use, copy that query.

 

Open Power BI Report Server version and paste the query into the RS version.

Go into Advanced Editor and make these changes.

Change  Web.BrowserContents  to  Web.Contents

If you are replacing an existing web connection, adjust the following step to be #"Extracted Table From Html" instead of what is currently says.

You will now have a refreshable version of the WEB connection.

  • SorenHElisa's avatar
    SorenHElisa
    Helper I
    2 years ago

    Thank you for you comment, but I can't see how this is any different from developing in PBIRS version directly. It will use the Web.Contents -function in PBIRS Desktop also when developing from scratch and the exact same code after that. It's not Power BI Desktop for RS that is having problems, it's the server. 

     

    Best regards, 

    Sören

    • pabeader's avatar
      pabeader
      Post Patron
      2 years ago

      It's not the server.  It's Microsofts decision to disable the HTML driver. 

      If you try it you will see that PBIRS and PBI create different M code for the WEB connection. 

      The one in PBI is close and only needs a few tweaks to be made useable.

       

      My workaround allows you to still update your WEB based data.