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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
LFM
Helper III
Helper III

Error fetching data for visual

Hello. When Im opening a PBI report from my organization, I get error messages for all the visuals as shown under. It seems like its only like this for my user. Other people in my organization have no problem with showing the visualizations. Why Im I having this problem?

LFM_1-1735762692756.png

LFM_2-1735762872984.png

 

 

1 ACCEPTED SOLUTION
LFM
Helper III
Helper III

Its working now after the PBI sematic model was shared through a link. Thanks for useful replies

View solution in original post

9 REPLIES 9
dataflip
Frequent Visitor

The "Error fetching data for visual" in Power BI typically indicates a problem with the underlying data source, query, or model configuration. Here are some troubleshooting steps specific to a Power BI Sales Dashboard:

Check the Data Source Connection:

Ensure the data source (SQL Server, Excel, or another database) is accessible.
Verify that credentials are correct and have the necessary permissions.
Inspect Query Settings:

Open Power Query Editor and review the applied steps to ensure there are no errors or broken transformations.
Test the query manually to see if it fetches data as expected.
Refresh the Dataset:

Go to the Power BI Service or Power BI Desktop and refresh the dataset.
Check for any errors during the refresh process.
Validate Relationships:

In the Model View, confirm that relationships between tables are correctly defined and not causing circular dependencies or mismatches.
Performance Issues:

If the dataset is too large, optimize the model by aggregating data or using measures effectively.
Check for any memory or processing limitations on the machine or Power BI Service.
Filters and Parameters:

Review filters applied to the visual to ensure they are not excluding data unexpectedly.
Verify that slicers or parameters are configured correctly.
Logs and Diagnostics:

Enable diagnostic logging in Power BI to capture detailed error messages.
Review the error message in detail to identify the root cause.
If the issue persists:

Share a screenshot or detailed error message for more targeted help.
Consider using Power BI's support resources or community forums for additional assistance.
💡 Looking for professional Power BI sales dashboards and templates? Check out Dataflip.co for pre-built, customizable dashboards and expert support!

LFM
Helper III
Helper III

Its working now after the PBI sematic model was shared through a link. Thanks for useful replies

Hi @LFM ,

I am happy to learn that you found the cause of the problem and fixed it.

Please accept your own reply or the replies above which help you as a solution, this will make it easier for other users who may be experiencing the same problem to find a solution.

Thank you for your understaning!

Best regards,

Lucy Chen

LFM
Helper III
Helper III

Thanks for replies. It might be RLS that is the reason. I will contact some of the admins to ask if its related to permissions. It is connected to a direct query sematic model. 

Hi @LFM ,

Thank you for your kind reply!

If you find a solution to the problem or have any progress, could you please share it with us here? In addition, if you have any other questions, please feel free to let us know, we are happy to provide you with more help!

Thank you for your understanding!

Best regards,

Lucy Chen

rit_ty7
Advocate I
Advocate I

Hello @LFM,
Maybe the issue stems from insufficient permissions, Row-Level Security (RLS), or cached data problems. Ensure your account has the correct read and build permissions on the dataset and that RLS rules aren’t restricting your access. Clear your browser cache or restart Power BI Desktop, sign out, and sign back in. Additionally, verify your data source credentials in Settings > Data Source Credentials to ensure they are valid and up-to-date. If the problem persists, contact your Power BI administrator for further assistance.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Ritesh Kumar,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xinc-msft
Community Support
Community Support

Thank you for the reply from danextian and lbendlin, your replies are all fantastic

Hi @LFM ,

1. Please make sure that the users are correctly added to the relevant roles in the RLS setup. Double-check if they have been assigned the proper roles in the Power BI Service:

  • Go to the Date Set in the Power BI Service and click the three dots (...) next to the data set, select Security, make sure the users are explicitly added to the roles here.

2. Sometimes a data source may cause a visual object to load incorrectly. For example, if the data source connection times out or if some column names in the data source have changed, it may cause the issue.

3. There can be a delay or issue with syncing RLS settings. You may want to try removing a user from the role, saving it, and then adding them back to force a refresh.

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Best regards,

Lucy Chen

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

 

danextian
Super User
Super User

Hi @LFM 

 

What is the data source of this specific report? Is it connected to a semantic model via direct query  or live connection? It is possible that there is RLS setup in the semantic model and some of the users are able to view just fine because they have the proper permission, either they've been added to a role or they're at least a member of the workspace where this semantic model is stored.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
lbendlin
Super User
Super User

is RLS involved? is a second semantic model involved?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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