Forum Discussion
PBRS Oct/2020 Release update causes errors in Scheduled Refresh
This has been fixed by Microsoft, see https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-October-2020-update-has-been-released/td-p/1503433
Are you having issues with other reports? or just this one? Anything different as it related to datasources connectivity here?
Yes, there is others reports with errors, and others is OK to refresh.
For example, another that is with error, this was the mensage at the firts time:
2020-10-29 16:01:38.6731|ERROR|5|Error Processing Data Model Refresh: SessionId: 14f19665-0ba8-4a27-85f9-94988a64d949, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface.
And now, after open/edit from PBIRS in PBIDS, refresh the Data, and save again the report in PBIRS, the error is the same as the other report when trying refresh:
*This report has MSSQL Datasource and Web/CSV.
2020-10-29 17:38:35.4243|ERROR|23|Error Processing Data Model Refresh: SessionId: 8c3c4b42-0bc8-4a38-8e9a-31bc9c3710e7, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: System.Core, A sequência não contém elementos.
The database operation was cancelled because of an earlier failure.
COM error: System.Core, A sequência não contém elementos.
Lúcio
Lucio,
Refresh for html datasources are not supported, was this something that was working in the previous release and started failing after you upgraded to october?
To be clear, refreshes from html would have your M expression as "Web.Page", "Web.BrowserContents". This is different than if you are fetching a csv file from a web location, which is indeed supported (in this case the M expression is Web.Contents).
Thanks
-gboreki