Error: Couldn't retrieve data for this visual. Please try again later.

[wjey9f]

This error has started showing up within the service for visuals that are using data from our SQL Database.  I am still able to view these visuals in the desktop version, but the published version is showing errors.  Previously, these visuals were appearing, but as of about two weeks ago, they have been erroring out.  I am unable to click on the "Show details" link for the error at the top but can click into the individual visual errors.  Any ideas on this?  I currently have a ticket open but the only "solutions" they came up with was to change some capitalization in power query which of course did nothing.. 

[monicapolo]

In my case I had to grant permissions to the main dataset (just the data, not the report), as the direct query data originates there, and it worked!

[v-janeyg-msft]

Hi, @wjey9f 

You can check the similar solved case: Solved: Couldn't load the data for this visual - Microsoft Power BI Community  Check if there is a problem with the query.

If you have opened the support ticket, you can also add details to ask the engineer.

Best Regards

Janey Guo

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

[arvindsingh802 · Accepted solution]

Are you suing direct query for this report, It seems your gateway connection is broken (refer top message)

If this post helps, then please consider Accept it as the solution and give it a thumbs up

[wjey9f]

Yes this is direct query.  And can you help explain what you mean by the gateway connection is broken?  We have it set up on our enterprise gateway and in the dataset configuration it appears that it is all connected.  The dataset even refreshes successfully.  Would the refresh still go through successfully if the gateway connection was broken?

[arvindsingh802]

what error meesge you get for individual visual ?

[wjey9f]

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.

Details -

Activity ID: 10f4a2fd-75b4-4ed8-be34-d851f030eee7
Request ID: 7ef18a4e-ff7b-b416-b1c3-c51ba47b709c
Correlation ID: 669e559a-ec80-913c-056e-a7c5788962da
Time: Wed Jun 23 2021 10:30:10 GMT-0500 (Central Daylight Time)
Service version: 13.0.16211.50
Client version: 2105.5.06379-train
Cluster URI: *removed as post wouldn't allow the HTML*

[kymramosrpo]

Hi - I'm guessing there's been no solution to this problem. If you've found any, please do share. Thank you!