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

kumar09 — Thu, 14 Mar 2019 18:20:47 GMT

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,

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

Anonymous — Mon, 24 Feb 2020 21:17:23 GMT

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

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

Anonymous — Wed, 12 Jan 2022 10:31:07 GMT

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.

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

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

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

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