Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am new to DAX and am trying to implement some dynamic RLS. The current table of users details looks like below:
User Email | User Name | Agent ID | Level of Access Required | Region | Company |
test@xxx.com | Test123 | 123 | Individual | USA | Company1 |
test@xxx.com | Test456 | 456 | Regional | UK | Company2 |
test@xxx.com | Test789 | 789 | National | AUS | Company3 |
What I want to do is give a user access at a level defined in 'Level of Access Required'.
This has 3 options:
1) National which will show all data for the specific company
2) Regional which will show all data for the specific company and the region
3) Individual which will show all data for user with the Agent ID
This table mentioned above will then be joined on to the other datasets within the report using a many to many join relationship I imagine?
Let me know if any further information is required.
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
Column1 | Column2 |
A | 1 |
B | 2.5 |
you will have to pass the filters from this table to the other tables in the data model, joins are one option to do that, but you could also use FILTER, etc.