Forum Discussion
PBIRS Scheduled Refresh Error - January 2021
I encounter the same issue for
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
Jan 2021 version when I upgrade from Oct 2020 version.
I fix this issue by uninstall Power BI Report Server and drop the ReportServer database and install Jan 2021 again.My Scheduled Refreshes were getting a similar error. The SQL Server Service Pack I was on was very outdated. Once we updated that last week to the most recent one, my Scheduled Refreshes now work. We are running SQL Server 2016.
Hi Icey
Thank you for your reply.
I had realised that via my research and removed as stated above but could not get the second part going with the COM error.
It works on the desktop and the credentials state they are successful in the data source section, but the reports fail to refresh.
Any idea why?
Microsoft EmployeeHi Anonymous - a few things:
- What datasource(s) are you using?
- Would you be able to turn on verbose logging per Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs ? We added some verbose logs that can help to uncover why this is happening
- If possible remove the existing report from PBIRS, re-upload the report, and re-enter credentials
- Try to refresh, and if it fails, capture the logs from ASEngineManagedRoot at that time.
- If you wouldn't mind, feel free to send me the logs with the verbose entries included in a direct message and I can take a look.
Hi gsprague,
same problem here: a PowerBI report deployed on a PreProduction PBIRS server, pointing to msdb on Production server. The report itself works fine; its planned schedulation throws this error:
SessionID: 7cf993dc-d568-4153-9eb5-ef1b456ab66d
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.I'e modded ReportingServicesService.exe.config file to obtain a verbose logging and today I forced a manual update of the report schedulation at 15:27, after the customer deleted and reuploaded his report. These are the errors I found:
File ASManagedRoot_2021_03_10_00_52_00.log:
2021-03-10 15:27:09.9384|ERROR|16|GetV3ConnectionString - Exception occured while retrieving credentials for data model connection string.System.Exception: No credentials were found for the datasource
at Microsoft.PowerBI.ReportServer.ASEngineManagedRoot.PBIRSConnectionDetailsProvider.GetV3ConnectionString(Guid rootActivityId, String userPrincipalName, String engineConnectionString, String[] datasourceIds, String contextualIdentity, Boolean isDirectQueryExecution, PBIDedicatedProviderType& providerType, String& connectionString)File RSPowerBI_2021_03_10_00_01_06.log:
2021-03-10 15:27:09.9853|ERROR|506|Error Processing Data Model Refresh: SessionId: 67fa4327-869d-4713-b80b-1e7e70aaaddc, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
The command has been canceled.. 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()
2021-03-10 15:27:09.9853|TRACE|506|Processing Data Model Refresh: SessionId: 67fa4327-869d-4713-b80b-1e7e70aaaddc, Status: Finished Refreshing the model.
2021-03-10 15:27:09.9853|ERROR|506|Error Processing Data Model Refresh: SessionId: 67fa4327-869d-4713-b80b-1e7e70aaaddc, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
The command has been canceled.. 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()
2021-03-10 15:27:09.9853|TRACE|506|Processing Data Model Refresh: SessionId: 67fa4327-869d-4713-b80b-1e7e70aaaddc, Status: Finished Data Refresh.Customers have noticed that this issue only occurs with PowerBI reports created in a dedicated PBIRS folder; other reports created via Reporting Services (therefore with shared datasources) have regularly working schedules. Security in PBIRS uses normal inheritance from Home. I hope this could help to solve the problem.