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,
