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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
wjey9f
Regular Visitor

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

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.. Call Center Error.PNG

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

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


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

7 REPLIES 7
monicapolo
Advocate I
Advocate I

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
Community Support
Community Support

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
Super User
Super User

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


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

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?

what error meesge you get for individual visual ?


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

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*

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors