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
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
@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
Any other post related to this to use as an example?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |