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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors