Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Data Formation is a table with clients and a table with projects. They are linked by clientID. Each object can have a "leader".
I am using Role Level Security to say if the logged in user is either, they should have access to the data. However, then I want the ability for a filter for the user to choose to look at their data as a "Client Leader" or a "Project Leader". For instance, if they select "Client Leader" they would see ALL projects, regardless of Project Leader.
I have a Table Named "Leader Type" with the two rows "Client" and "Project" available to use as a filter. I cannot figure out how to allow this filtering to occur and get the data back with only 1 RLS group, plus a filter. Any help is appreciated!
Hi @dcheckai,
Instead of thinking of showing your users a filter for seeing the Client Leader view or the Project View, you can create 2 Bookmarks one for Client and other one for Project.
Now you can implement RLS in your report.
This RLS will be applicable in the report for both the bookmarks based on the security that you provide in the Data Model
Hi @dcheckai,
Would you please provide some dummy data to illustrate your scenario? How to Get Your Question Answered Quickly
How does the RLS work to restrict data access in your scenario?
"For instance, if they select "Client Leader" they would see ALL projects, regardless of Project Leader." Please show some examples.
Regards,
Yuliana Gu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |