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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kumar09
Frequent Visitor

Power BI Report Widgets Failing randomly with failed to get connection string for model

Hi Power BI Community - 

 

We are facing an on going issue with Power BI reports hosted on Power BI Report Server.

 

Issue: When ever an user loads a Power BI report some of the widgets in the report fail to load with a "X" mark and if we expand the see details link below is the error message it shows in the UI.

 

/** Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Http Status Code: 500
Request ID: 5f2c5c25-3fd8-c638-6fde-74cfc1479623
Time: Thu Mar 14 2019 13:57:35 GMT-0400 (Eastern Daylight Time)
Version: 15.0.1102.235  **/

 

When I dig into the logs I see the below error message.

 

/** 2019-03-14 13:55:38.7242|ERROR|144|Unhandled error in the Web API|POST http://xxxxx/powerbi/api/explore/reports/bee13f4d-7986-43c6-b072-8910422f080f/querydata - Response Unknown| RequestID = 5f2c5c25-3fd8-c638-6fde-74cfc1479623 ClientSessionID = ff88bfbc-6fd2-ef00-7412-9e4dfb188b94 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() **/

 

The widgets will load if we refresh the page again. But the entire behaviour is random. Not able to identify the root cause. I was wondering if anyone out there are facing the similar issues and were able to resolve this one.

Below are some of the report & environment charcterstics:

1. Power BI report developed in imported mode.

2. Content Size - 0.26 MB

3. PBIRS is scaled out environment on two servers.

 

Any help would be really appreciated.

 

-Thanks,

 

 

2 REPLIES 2
Rastenberger
Regular Visitor

We are using the same setup with direct query on prem and we get the same random errors. Does not anyone has come to a solution?

 

- Regards

J.R.

damuyada
Frequent Visitor

we are facing a similar issue in our organization as well. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.