cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jerome22
Regular Visitor

"Couldn't load the data for this visual" error for 1 user only

Hi,

 

I have 1 user (maybe few more) in my company which is receiving the error "Couldn't load the data for this visual" on a published app I made.

the user can see other reports only 1 is failing.

but everybody else can see the report without any issue.

 

I have no idea what could be the cause for that.

there is no row level security in place.

it's a composite model connected to 2 datasets.

 

how I can diagnose and solve the issue?

2 ACCEPTED SOLUTIONS
gauthamboppana
Solution Supplier
Solution Supplier

Jerome22 -  Assuming you have checked the RLS. Does the report has multiple visuals and only one visual is not loading?  Or the entire report is not loading? 

Please try the below and see if it works.

1) If the entire report is not loading, it might be worth adding the user to the report and dataset permissions (click on the dots and select Manage permissions on the report  & dataset), and check if it resolves the issues.

 

Capture.PNG


2) In the Datasource settings, check the data source credentials and see if the option "Report Viewers can only see this data source with their own credentials' is selected. If yes, then turn it off.

View solution in original post

I added the user to the dataset , yes, this solved the issue...

but the user had access to this dataset, he can access other reports connected to it.

and can access the application deployed, so he is member of the global group in place in the company.

 

it's very very strange.

I'll check with the persons in charge of the security to validate all the membership of this user.

 

View solution in original post

8 REPLIES 8
Jerome22
Regular Visitor

ok I found the problem.

I grant access to global groups in the company and , for some reasons, my user is not recognized in them.

so I grant access to my dataset to this user and the  problem was solved.

 

but don't ask me why... another report connected to the same dataset through the same application (without a composite model) and the user was able to see the data properly!!!

 

so the same dataset accessed through 2 reports in the same application, 1 working 1 not working until I grant access to the user in trouble...

🙂

 

Hi @Jerome22 


It sounds to me like the user was maybe no added to the global group?





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

Proud to be a Super User!







Power BI Blog

gauthamboppana
Solution Supplier
Solution Supplier

Jerome22 -  Assuming you have checked the RLS. Does the report has multiple visuals and only one visual is not loading?  Or the entire report is not loading? 

Please try the below and see if it works.

1) If the entire report is not loading, it might be worth adding the user to the report and dataset permissions (click on the dots and select Manage permissions on the report  & dataset), and check if it resolves the issues.

 

Capture.PNG


2) In the Datasource settings, check the data source credentials and see if the option "Report Viewers can only see this data source with their own credentials' is selected. If yes, then turn it off.

I added the user to the dataset , yes, this solved the issue...

but the user had access to this dataset, he can access other reports connected to it.

and can access the application deployed, so he is member of the global group in place in the company.

 

it's very very strange.

I'll check with the persons in charge of the security to validate all the membership of this user.

 

@Jerome22  - Cool, that's great to hear.  If my post helped you to reslve your issue, then please give a thumbs up and  consider Accept it as the solution to help the other members find it more quickly. Thank you.

@Jerome22  - Hope my resposne helped you to resolve the issue. Can you mark my post as a solution. It will help other users with similar issue. 

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

GilbertQ
Super User
Super User

Hi @Jerome22 

 

Could you confirm on the composite model that the underlying Power BI Dataset does not have RLS enabled?

Also could you verify that the users have build permssions on the composite datasets?





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

Proud to be a Super User!







Power BI Blog

no, there is no RLS in place at all.

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors