Power BI Service : Couldn't retrieve the data for this visual. Please try again later.

[naveenanda_vam]

Data source is SQL server. Only reports with this data source are having this error and it only started today.

The gateway is online connected fine, but the data does not display in Power BI service, only Power BI desktop. No RLS set up

Activity ID: 78830e59-870a-4f7c-b779-42c5a892e80f
Request ID: 5fe0e482-9e38-438a-8b07-6b652bc784c5
Correlation ID: f0a7e009-4756-c271-73c0-a7c29b518376
Time: Tue Nov 05 2024 14:55:21 GMT+0530 (India Standard Time)
Service version: 13.0.24611.45
Client version: 2410.4.21630-train
Cluster URI: https://wabi-us-north-central-b-redirect.analysis.windows.net/

[Anonymous]

Hi @naveenanda_vam ,

Based on the testing, I am testing import mode and DirectQuery mode to get the data. I can see the reports with SQL Server data source in power bi service.

So, try to check the SQL query and try again open the report.

You can also view the following documents to learn more information

Solved: Couldn't load the data for this visual - Microsoft Fabric Community

Solved: Error: Couldn't retrieve data for this visual. Pl... - Microsoft Fabric Community

Troubleshooting tile errors - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. Unless you are working with DirectQuery and the visual you want to build uses too much data, then my assumption is that you might be using a measure with your visual that is responsible for retrieving too much data. Check if the data can be loaded when you remove measures one by one, to identify the measure(s) that is/are responsible. You can check that editing the report at Service. Once you know which measure is, analyze the code to check if there is a way to optimize it or consider to post the measure code here so we can help with that.

I hope that helps,