Forum Discussion

Jacob_Li's avatar
Jacob_Li
Frequent Visitor
4 years ago
Solved

Error: Couldn't load the data for this visual

It is a weird problem and it shows up recently. Suddenly nearly all of my reports could not display visuals correctly. The error message is given below.

 

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.
 
Activity ID: 91b2103e-ff11-40de-946d-6cc4f44a2397
Request ID: ceedea02-60ce-4c7f-eca4-d36cdc88e071
Correlation ID: 8f0db4eb-476c-8e46-ae73-edec429fae81
Time: Tue May 03 2022 10:03:10 GMT-0500 (Central Daylight Time)
Service version: 13.0.18173.56
Client version: 2204.4.11089-train
Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net
 
My data sources mainly include three parts: SQL Server, Sharepoint files, Web. Since something in common with the problematic visuals is that they are have measures from tables in these Sharepoint files, I doubt that the connection between the Sharepoint and On-premises gateway is down. But everything works fine on my pbix file. I reinstalled the gateway yesterday. It works last day but today it again throws me these errors. I've read some posts, but I am not sure which problem and solution applies to my case.
 
By the way several days ago, I noticed the error message below, informing me that there's no available gateway.

Could it be that I am using the files extracting from sharepoint, but after merging them within the Power Query editor, Power Bi service is unable to identify them? Any help or suggestions are appreciated. Thanks in advance.

Display Error
on-premises gateway
Refresh
sharepoint Folder
  • lbendlin's avatar
    lbendlin
    4 years ago

    most likely your credentials are invalid or your OAUTH2 session has expired.  Go to the dataset settings and update all credentials.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    most likely your credentials are invalid or your OAUTH2 session has expired.  Go to the dataset settings and update all credentials.

    • Jacob_Li's avatar
      Jacob_Li
      Frequent Visitor
      4 years ago

      Thanks, I tried to exclude all the possible solutions. And I found that it was due to the mixed data mode, I switched it to import, and now it is fixed.