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.
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.