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

[SorenHElisa]

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 refresh throws the following error:

Data source error: Login failed for data source ‘Unknown’.

When clicking the [i] after error message, the following is shown:

essionID: 3ed14127-ea01-441f-a849-ca66d74c4755
[0] -1055784932: Expression.Error: The module named 'Html' has been disabled in this context.. . The exception was raised by the IDbCommand interface.

from RSPowerBI_<>.log file:

2022-10-27 08:49:01.0640|ERROR|96|Error Processing Data Model Refresh: SessionId: 3ed14127-ea01-441f-a849-ca66d74c4755, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'Expression.Error: The module named 'Html' has been disabled in this context.. . The exception was raised by the IDbCommand interface.
'.
at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, IEnumerable`1 parameters, String clientSessionId)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2022-10-27 08:49:01.1161|ERROR|96|Error Processing Data Model Refresh: SessionId: 3ed14127-ea01-441f-a849-ca66d74c4755, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'Expression.Error: The module named 'Html' has been disabled in this context.. . The exception was raised by the IDbCommand interface.
'.
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()

M Query code in use:

let
    Source = Web.Page(Web.Contents("https://www.worldometers.info/coronavirus/")),
    Data2 = Source{2}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data2,{{"#", Int64.Type}, {"Country, Other", type text}, {"Total Cases", type text}, {"New Cases", type number}, {"Total Deaths", type text}, {"New Deaths", type number}, {"Total Recovered", type text}, {"New Recovered", type text}, {"Active Cases", type text}, {"Serious, Critical", type number}, {"Tot Cases/ 1M pop", type number}, {"Deaths/ 1M pop", type text}, {"Total Tests", type text}, {"Tests/ #(lf)1M pop", type text}, {"Population", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([#"Country, Other"] <> "Total:"))
in
    #"Filtered Rows"

PBIRS version:

Version1.15.8300.38452(September 2022)

Also happening in version:

Version1.13.8054.40631(January 2022)

All other datasources in use (like ODBC, Oracle, SSAS) are working as expected.

Is the functionality disabled in some config files? A bug in PBIRS?

Best regards,

Sören

[v-henryk-mstf · Accepted solution]

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.

[SorenHElisa]

Hi,

Thanks Henry for pointing out this. I had completely missed the footnote regarding restrictions on web content. 

Have a great day,

Sören

Note to self: never skip footnotes, although they seem not to concern the actual problem.