Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

couldn't load the data for this visual - randomly with local data


When publishing the report to the web and starting to move the date slicer forward or backward sometimes subject error shows with different visuals.  

I am using a free power BI desktop, Data linked locally from excel to BI, not using any RLS nor Semicolon with SQL.

screenshots below and sample linked here:










Community Support
Community Support

Hi @Mohamed_Khalaf 


I cannot access the file in your link, what is that file? If it's a sample pbix file, can you please share it again after removing sensitive data? 


From the screenshots, the visuals that display the error message seem to be Card, Multi-row card and Gauge visuals. If it's not possible to provide a sample file, can you tell me which fields are used in them? Are they column fields or measure fields? If they are column fields, can you show their names, data types and aggregation types? If they are measures, can you show their DAX codes?


Additionally, although the visuals show an error with the same subject "couldn't load the data for this visual", the detailed cause might be different. Can you click See details and show the detailed error message under that subject?


Best Regards,
Community Support Team _ Jing

Hi @v-jingzhang,

Please find the new link:

as you will see with the sample file, it's a column and calculated fields.

and it's the same error message as the subject with all errors popped up (

couldn't load the data for this visual)


Appreciate your concern and thanks in advance.


Hi @Mohamed_Khalaf 


I tested your sample file on my computer. It works well without any error messages. Perhaps the problem is not in the report file. Do you have other computers to test this report file? Or can you publish this file to a workspace in Power BI Service and check whether it works well on the Service? 


If you test it on your computer, close other applications that are not in use then open this report file.  




Best Regards,
Community Support Team _ Jing

Hi @v-jingzhang,

The report has no errors until it was published on the web errors start to show from time to time.



Mohamed Khalaf

Hi @Mohamed_Khalaf 


Do you mean publishing it to a workspace in Power BI Service? Or using the publish to web feature? And it is in a workspace hold in premium capacity or shared capacity?




Hi @v-jingzhang,


I meant published to the web with Power BI service like the below link; and not with the shared capacity.





Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors