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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ryan_b_fiting
Post Patron
Post Patron

DAX Measure that ignores Row level security

Hello Community - 

 

I am looking for some assistance and guidance on understanding if there is a way to 'ignore' Row Level Security roles on one specific measure? 

I have several healthcare providers who see patients regularly, but the patient does not always book future appointments with the same provider.  We have the RLS set up at the provider level so when they log in, they can only see the data associated with their UPN.  However, I want to create one measure that will skip over that RLS role so that the provider can see the number of future appointments for a patient they have seen in the past, even if the futurue appointments are not booked with the provider that is viewing their report.

 

Is this possible, or is this just a dream for my client and I to resolve?

Thanks in Advance Community!

Ryan Fiting

2 REPLIES 2
amitchandak
Super User
Super User

@ryan_b_fiting , if you have used RLS< you can not ignore for a measure. We usually create Table(Fact) where RLS do apply and create a measure from that

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Any other post related to this to use as an example?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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