Forum Discussion

Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Power BI Report Server October 2020 update has been released.

Hello,   I am pleased to announce we have released an update to the Power BI Report Server (October 2020) with several fixes to problems commonly reported here on the Power BI Community Forums.  Th...
PBI Desktop on-prem
PBIRS Oct 2020
Report Server
Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Some rapid fire followup questions:

  1. Are you having issues with all reports or just this one?
  2. Can you say the types of datasources found within this report?
  3. Anything different/unique as it related to datasources connectivity in it?
  4. I assume the refresh fails consistently as well?
  5. Just double checking you are on Version: 1.9.7627.11028 (Build 15.0.1104.264). You can find this version in the portal under the about dialog.
tjcps's avatar
tjcps
Regular Visitor
5 years ago

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. 

  • tjcps's avatar
    tjcps
    Regular Visitor
    5 years ago

    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()