Hi,
we have an interesting error with a specific PBIX. When a user tries to open this PBIX in most of cases it goes fine, but sometimes the user gets an error which points out the lack of permissions to open the report and the RS logs this error message below. User retries and in 1 minute later everything goes fine again.
2020-03-31 10:18:46.2747|ERROR|61|Failed to get connection string for model | RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model
2020-03-31 10:18:46.2747|ERROR|107|GetDataSource ERROR for catalogItem=6fd6e1dd-16f4-4f56-a5af-86885488ca1f, Exception=Failed to get connection string for model , ElapsedMs=56| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65
2020-03-31 10:18:46.2747|INFO|107|Attempting to re-stream the model 6fd6e1dd-16f4-4f56-a5af-86885488ca1f for request 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb, session a6a9005d-6395-fa0c-fc5e-095a286c1f65| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65
2020-03-31 10:18:46.5248|ERROR|145|Failed to get connection string for model | RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model
2020-03-31 10:18:46.5248|ERROR|80|GetDataSource ERROR for catalogItem=6fd6e1dd-16f4-4f56-a5af-86885488ca1f, Exception=Failed to get connection string for model , ElapsedMs=45| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65
2020-03-31 10:18:46.5248|ERROR|57|Failure in conceptualschema| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model
at Microsoft.PowerBI.ReportServer.WebApi.ASConnection.RSDataSourceProvider.GetDataSource(Int64 modelId)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewDataSourceProvider.GetDataSourceInfo(String modelIdFromClient, RSDataSourceConnection& rsDataSourceConnection, IASConnectionInfo& asConnectionInfo)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.CreateModelKeyFromId(String modelIdFromClient, String maxModelMetadataVersion)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId)
at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>b__8_0()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ExploreHost.ExploreClient.<GetClientConceptualSchemaAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSExploreHost.<GetConceptualSchemaAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetConceptualSchemaAsync>d__21.MoveNext()
The Datasource of this PBIX refers to two SQL relational DB and an Excel file.
DataSource1: Conn.Type: SQL | Conn.String: skrbipsql;START_TAR_DWH | Auth.Type: Windows Authentication
DataSource2: Conn.Type: File | Conn.String: \\krtbidw\napi\kosz\2019-2020 kösz 8 mell. 9 b függelék.xlsx | Auth.Type: Windows Authentication
DataSource3: Conn.Type: SQL | Conn.String: skrtarbipsql;DM_TMEN | Auth.Type: Windows Authentication
Is it possible that the Report Server "doesn't like" this combination of DataSource declarations, or it seems to be a bug, or what? Any suggestions?
Thanks,
NSz.
