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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
KG1
Resolver I
Resolver I

RLS Help

I need to produce a 1 page report

 

The top half of the page summarises all actions and their status

 

When the user clicks on a bar chart then the detail below should update to only show the actions applicable to their part of the business and not show the detail of any other parts of the business but I dont know how to do this.

 

At the moment I have created 2 tables and applied the RLS to the table which is populating the detail table but when the user clicks on the graphs they are static and dont filter the table below

 

KG1_0-1707321937365.png

 

2 ACCEPTED SOLUTIONS

No problem. No, you need the RLS to still be applied to the detail table so they only see their own items, the bridge table will allow both tables (one with RLS and one without) to be filtered. In the bar chart visual you will utilize the field from the bridge table instead of your unrestricted table.





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

Proud to be a Super User!





View solution in original post

Hi  - thank you very much - that has worked perfectly

View solution in original post

6 REPLIES 6
Daniel29195
Super User
Super User

@KG1 

is the table populating the details connected to other tables ? 

 

 

audreygerred
Super User
Super User

Can you share a screenshot of your joins in the model? I am assuming that you want it so that when a user clicks on Overdue (or any other item in the bar), the table below only shows Overdue items for the specified user, is that correct? My guess is, right now there is no relationship that will make this work. You will likely need a bridge table with each Audit Action that joins to each of your fact tables, that way it will filter both.





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

Proud to be a Super User!





Thank you for replying - the data model is very simple - 1 lookup table sorting the due date status and the 2 identical fact tables - would I apply the RLS to to the bridge table?

 

No problem. No, you need the RLS to still be applied to the detail table so they only see their own items, the bridge table will allow both tables (one with RLS and one without) to be filtered. In the bar chart visual you will utilize the field from the bridge table instead of your unrestricted table.





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

Proud to be a Super User!





Hi  - thank you very much - that has worked perfectly

You're very welcome!





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

Proud to be a Super User!





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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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