Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello,
I have prepared RLS access table which contains following attributes:
Example data:
user1@xyz.com, ALL
user4@xyz.com, ALL
now I need to prepare DAX formula which will be applied on one of the dimension. It's need to check if user have access to specific business value and if there is ALL value then he need to have access to all data no matter what. How to do that in optimal way?
thank you for your help and regards
Solved! Go to Solution.
Hi @Anonymous ,
You could create a CONTAINS Function.
CONTAINS (
Table1,
Table1[xxxx], USERPRINCIPALNAME (),
Table1[xxx], "All"
)
||
xxxxxxxxxxxx
Another way is to give these "all" users edit permission in the workspace.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You could create a CONTAINS Function.
CONTAINS (
Table1,
Table1[xxxx], USERPRINCIPALNAME (),
Table1[xxx], "All"
)
||
xxxxxxxxxxxx
Another way is to give these "all" users edit permission in the workspace.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @Anonymous ,
that depends on your data model. In the best case, it should be enough to check for the username. In the mentioned table, you would have to add the following code for the RLS:
[UserUPN] = USERPRINCIPALNAME()
Then it might ne necessary to also implement the check in your fact table. The whole procedure is well described by our friends from RADACAD. Check the following tutorial:
What Do You Need to Implement Dynamic Row-Level Security in Power BI? - RADACAD
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |