Forum Discussion
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the ds
- 5 years ago
If your issue ends up showing "Datasource XXXXXX not found" at some points, there is a resolution here that might help: Fix for "Datasource XXXXXX Not Found" PowerBI Refr... - Microsoft Power BI Community
Scheduled refresh not working with latest version:
Power BI Report Server
Version 1.10.7698.27886
Power BI Desktop
Version 2.88.1382.0 64-bit (January 2021)
From RSPowerBI log:
2021-03-19 13:00:28.4763|ERROR|66|Error Processing Data Model Refresh: SessionId: e9647ff5-b849-4f21-bf87-9d1a0c8e0b94, 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.
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
'.
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()
From ASManagedRoot log:
2021-03-19 13:00:28.0700|TRACE|10|GetV3ConnectionString - dataSourceIds: {"protocol":"file","address":{"path":"\\\\XYZABC\\Deadpool$\\Deadpool_Data_Files\\Adjustments-Old.csv"},"authentication":null,"query":null}; Root activity ID: d2ae1cbb-cfb5-43f2-b3d8-4f52b8bfcf28.
2021-03-19 13:00:28.0700|TRACE|10|GetDatasources - Looking for credentials based on connection string. Root activity ID: d2ae1cbb-cfb5-43f2-b3d8-4f52b8bfcf28.
2021-03-19 13:00:28.0700|INFO|10|Getting data sources in the model for connection string for databaseName = d5151e44-feed-4bc7-90cf-5a4273b99958_-525095226
2021-03-19 13:00:28.0700|TRACE|91|Failed to find a matching datasource for ConnectionString \\XYZABC\Deadpool$\Deadpool_data_files\adjustments-old.csv in database d5151e44-feed-4bc7-90cf-5a4273b99958_-525095226. Available datasources found were DataSourceIdentifier: 2BE5BD0BF91B03EE11B67575DEF9E0206D31F5976C3A12F6B39A09E074530DD7, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????????????,DataSourceIdentifier: 5032E4FD176554754528992B9498094BD725F95BE61AC034FEB3E85B4F26EEE5, AuthKind: File, AuthType: Windows, ConnectionString: ?????????????????????????????????????????????????_??????????,DataSourceIdentifier: 684DA2F197A79C09F8372666E8CDE0347AE5C58695FCA5AE5568710AAF47E78F, AuthKind: File, AuthType: Windows, ConnectionString: ?????????????????????????????????????????????????_??????????????,DataSourceIdentifier: 98828F3672633768B8D6692AB497A043A71919AC77DC4ECE7FAC4975D0120E1A, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????,DataSourceIdentifier: 9984BF017312C7CB377E4D5EC99F6F18AE5FC9F6E16439BD653AC370F5693C9D, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????????????????????????????,DataSourceIdentifier: A6997D6A781D0359AB392B0237FBB1278FBE9396CA3FF18D7D6A61708A0CC51F, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????????,DataSourceIdentifier: A9E998531E1F1CDA6ECAB278DA93B832A6411B7C50B903BF8DDF2D0BE5C346CC, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????????????????,DataSourceIdentifier: CC73019E31E1DC4DB0D3AF1B200407F0792C78B893EDD15412A0D1FF033479ED, AuthKind: File, AuthType: Windows, ConnectionString: ???????????????????????????????????????????-?????????????Î??,DataSourceIdentifier: D4BA434E8E24A332C5699E1CDFC13DB517FF155A0343E84B6AF9589E6B756F40, AuthKind: Folder, AuthType: Windows, ConnectionString: ?????????????????????????????????????????¦??,DataSourceIdentifier: E4203739C56C79D77E4694C1E15C8057EFA906E033D3557F777CB2802C145F42, AuthKind: File, AuthType: Windows, ConnectionString: ????????????????????????????????????????????????????????????????
2021-03-19 13:00:28.0700|TRACE|10|GetDatasources - Data Source Not found, looking for datasource based on path-based hash. Root activity ID: d2ae1cbb-cfb5-43f2-b3d8-4f52b8bfcf28.
2021-03-19 13:00:28.0700|INFO|10|Getting data sources in the model for hashedDataSourceId = FDC4413CB4405094BC897964968779E7B7D05C9113E56F614447D5ADF91030EF and databaseName = d5151e44-feed-4bc7-90cf-5a4273b99958_-525095226
2021-03-19 13:00:28.0700|TRACE|10|GetDatasources - Data Source Not found, looking for legacy full hash. Root activity ID: d2ae1cbb-cfb5-43f2-b3d8-4f52b8bfcf28.
2021-03-19 13:00:28.0700|INFO|10|Getting data sources in the model for hashedDataSourceId = BDC0C1A484D540BA653FD8238F93B5FDCCE0A4CC05E6E766D0EE82DE0DA7CEE5 and databaseName = d5151e44-feed-4bc7-90cf-5a4273b99958_-525095226
2021-03-19 13:00:28.0700|WARN|10|GetDatasources - Unable to find matching datasources with the following datasourceIds: {"protocol":"file","address":{"path":"\\\\XYZABC\\Deadpool$\\Deadpool_Data_Files\\Adjustments-Old.csv"},"authentication":null,"query":null}
2021-03-19 13:00:28.0700|ERROR|10|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)