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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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.

Anonymous
Not applicable

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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