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:
error details shows:
 -1055784932: The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface.  -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
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 !
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:
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.
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?
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.
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
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!