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
TrentS
Advocate II
Advocate II

Row Level Security and Filters

Good day all,

 

Have an interesting user experience happening that I need suggestions on.

We have RLS configured for Countries and Geographical regions. Multiple table filters set in RLS. This restricts the data seen to just that users region/country. Pretty standard.

One user (so far) has reported multiple instances where filters on multiple pages will list additional countries not within their area. (with Screenshots) No data is displayed and we have confirmed that these areas are not within the filters set in RLS.

If the page is refreshed, the options do not show up in the filters. 

It almost seems like RLS is "slow" in being applied. (These are large (250mb) reports on a premium node.)

Any ideas on where to go with this one?

 

Many thanks for your time and insights.

Trent

5 REPLIES 5
v-xicai
Community Support
Community Support

Hi @TrentS ,

 

The RLS will be applied to read-only members. If you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

 

For reference:

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#using-rls-with-app-workspaces-in-power-b... ,

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

@parry2k, I agree! Very odd behavior. None of the slicers showing the additional countries have anything selected as default. The geography setting does not show anything additional to match the incorrect country either. (The person should see Latin America countries but not European however when France shows in the country list Europe does NOT show up in the Geo slicer.)

 

@Amy, Thanks Amy but the user is set to read only and does not actually see any of the data. The odd country selection only appears in the slicer.

 

Trent

parry2k
Super User
Super User

@TrentS how you are connected to data source, direct query or import? Are there selections in slicers for these countries? If yes then these will show up as slicer value and after unselect, it will disappear.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thanks for the reply, Parry.

 

The data set is an import. The odd countries showing up in the slicers are seemingly random and meet the criteria set in the RLS filters to be excluded from that users view. Again, no data is displayed when they are selected and they go away on a page refresh.

We have verified that our country dim table is set correctly matching country/regions. The other tables referenced in the RLS rules that may have their own country field (for various reasons) are also set correctly.

 

When I view that same Role, I do not see those countries in the slicers.

 

Trent

@TrentS  very hard to tell what is going on? Do you have value previously selected in the slicer before you test another user for RLS?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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