Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nagy3Sz
Frequent Visitor

ERROR: Failed to get connection string for model in Reports Server

 

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.

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.