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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
daanp
Helper I
Helper I

Visuals only load with users that are part of the workgroup

Hello all,

 

Since of this morning, visuals in my report only load with users that are a member of the work group.

Reports shared with users that arent part of the work group get an error saying the visual could not load. (http error 401)

 

This wasn't an issue before. 

 

Any advice/ideas?

1 ACCEPTED SOLUTION

Ok, so i figured out what went wrong, but i do think this is a bug.

 

I created a row level security rule, but didnt add any user to it, at the time i wasnt sure if i was going to use it. 

 

just now, i created another row level security rule but left it blank, so every user added to the rule would see all the data.

I added users to the rule. et voila, visuals are working again for those specific users. 

This also explains why i didnt had any problems with my other PBIX files. They didnt had row lvl security.

 

 

View solution in original post

8 REPLIES 8

The only thing I find strange is that it did work before. I would not expect users that are not part of a workgroup to be able to see anything. 

 

I wrote an article about this here http://exceleratorbi.com.au/top-tips-for-sharing-content-using-power-bi/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Any thoughts on what could generate the 401 error? 

My guess is that previously it was incorrectly displaying the visuals to people that should not be able to see them, and now it is correctly not displaying them to people who should not be able to see them. If someone shares a URL from a workgroup to another person who is not in the workgroup, the correct behaviour is to not show the visualisation. That may be an error code or something else. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

What's also weird, is that this only happens on a certain dataset/PBIX file. my other datasets are working just fine.

 

So i guess the problem is related to that specific PBIX file.

 

Very annoying, cause this renders power BI useless to our organisation.

Maybe I am missing something here. I don't see how the software is useless if you share it with someone who

does not have access, and they can't see anything. What am I not understanding with your scenario?



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

I created a report,

i pinned some content to a dashboard,

then i shared the dashboard with user A.

Last week user A could see the dashboard and open the report, all visuals were shown.

 

Today, user A opens the report and sees a visual with the error: Could not open visual. (error 401).

If i open the same report, i can see the visual correctly.

 

Nothing changed in the PBIX file( well, something probably has changed, but i didnt do it 😉 )

Ok, so i figured out what went wrong, but i do think this is a bug.

 

I created a row level security rule, but didnt add any user to it, at the time i wasnt sure if i was going to use it. 

 

just now, i created another row level security rule but left it blank, so every user added to the rule would see all the data.

I added users to the rule. et voila, visuals are working again for those specific users. 

This also explains why i didnt had any problems with my other PBIX files. They didnt had row lvl security.

 

 

I'm glad you sorted it out.  You more details description doesn't mention anything about workgroups.  Definitely anyone with a shared dashboard should continue to see what has been shared. RLS is an opt in model. So if you don't add any users, then they won't be able to see the data. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors