Forum Discussion
Power BI Report Server October 2020 update has been released.
Same problem here. My pbix files has Web Content Data Source and SQL Server data sources. The PBIXs files that has only SQL Server data sources works fine. But the others who has Web Content fails.
In the Portal, the this is the message:
...
[0] -1056505856: COM error: System.Core, A sequência não contém elementos.
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[2] -1055784828: The database operation was cancelled because of an earlier failure.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
In the log of the SSRS:
2020-11-19 11:30:06.0997|ERROR|69|Error Processing Data Model Refresh: ...
Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: System.Core.
'.
em 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)
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()