Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mhamdy
Frequent Visitor

The module named 'Html' has been disabled in this context

Hey Guys,

 

I am running a local power bi reporting server ( on-premises), one of my reports greps data from my company website ( hosted externally). After updating to October 2020, I noticed that the report schedule refresh fails to update data with error as shown:

1.PNG

 

error details shows:

 

 

2.PNG

 

 

 

[0] -1055784932: The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface. 

 

On the other hand, I successfully refreshed the data when I opened the report using the powerBI desktop October 2020 with no errors. But still schedule refresh fails to update data

9 REPLIES 9
pabeader
Post Patron
Post Patron

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.

Did anyone get a solution for this? I am also getting the same error as below:

 

nilesh_amrutkar_0-1665282022461.png

 

Dreamer_Argento
Frequent Visitor

I have a similar problem (The module named 'Html' has been disabled in this context) with  RS October 2020. I did not have problems with RS May 2020.

The report schedule refresh fails to update data from https://es.wikipedia.org/wiki/Pandemia_de_enfermedad_por_coronavirus_de_2020_en_Argentina

I wait for help. Thanks !

 

 

 

mhamdy
Frequent Visitor

How could you consider that the problem solved while none of you provided a way to handle the error

gboreki
Employee
Employee

The html module is not available in Power Bi Report Server, this prevents refresh o reports that use data directly from html (if by the other hand you use well formatted data from web, such as CSv, xml, json refreshes should work fine). Can you confirm if your refreshes were working in previous releases? In the meantime we are clarifying in documentation exactly which m expressions are supported during refresh:

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

 

Thanks

gboreki

Anonymous
Not applicable

Hi gboreki,

The option which you mentioned in the bracket is the one which my dashboard was collecting data from. 

And after investigation I found it is partially working. Please refer to the image attached. There are tow Html formats. Html and Html (legacy). Both options refresh via Desktop version. And both also did for the May RS version. But since the October 2020, it refreshes only for Html and not for Html (legacy). Which is a serious pain, because what Html (legacy) used to do was provide the same snapshot of the xls spreadsheet data, whereas Html breaks the table into multiple tables. 

 

Hope this helps your testing further.

 

Regards,

Modasher.

 

modasher_0-1606252104313.png

 

Thanks for the context. If I understand your use case correctly you are loading files from a folder and processing them as html, but they are originaly excel files? and they can't be processed as excel files?

Anonymous
Not applicable

Hi gboreki,

Nope, unfortunately not. As the format is xls (an older version of xlsx), we needed to change it to another format when the error would come up (attached in image). After changing the format, the data would work and get scheduled refresh successfully back in May 2020.

modasher_0-1606271714541.png

 

 

Anonymous
Not applicable

Hi,

 

Even I faced this issue just now. I am pretty sure I have to lodge a ticket with the support team.

Very curious how so many errors from so many different sources/companies, all with scheduled refreshes are stacking up. But apparently, these issues with Oct 2020 edition can't be replicated in the Power BI team's development environment currently.  

You can find more details here: Power BI Report Server October 2020 update has bee... - Microsoft Power BI Community

modasher_0-1606188666307.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.