Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
I wanted to apply row level security on fields from multiple tables as like below.
Employee[Dept]="Sales" and Location[City]="Paris"
Problem is that I can apply dax expression on single table only in power BI desktop.May I know how to create role based on fields from multiple tables.
Thanks,
Solved! Go to Solution.
Under single role, you can apply filter conditions for multiple tables, one by one.
Example click Employee table and apply the filter condition. [Dept]="Sales"
Then click Location table and apply the next filter condition. [City]="Paris"
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@shashankp1 , refer these
row-level-security-patterns has explained few things pretty well
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
Thanks Amit for providing links ,all are useful.Thanks.
Under single role, you can apply filter conditions for multiple tables, one by one.
Example click Employee table and apply the filter condition. [Dept]="Sales"
Then click Location table and apply the next filter condition. [City]="Paris"
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Thanks for the quick reply.
So this will create AND condition right.just for my info,what if I want to create "OR" condition.So any different approach.Once again Thanks.
To create an "OR" condition I did by creating 2 different roles. In this case one role for
Employee table and apply the filter condition. [Dept]="Sales"
another role for Location table and apply the next filter condition. [City]="Paris"
An then asign the desired member to the 2 roles, so this member will see all "Sales" and all "Paris"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |