Forum Discussion
Dynamic RLS in power BI
krishma ,
You can refer to the below link for a simple explanation on Dynamic RLS in Power BI
Dynamic Row Level Security with Power BI Made Simple - RADACAD
The Above page speaks about implementing for one column.
In short, the Below should be the relations between the tables.
Apply the Userprincipalname() filter on both User and Region details and User details as per account tables.
Then the above two tables to be connected to the sales table such that they filter the sales table
Regards,
Hi
Thanks for helping but this loution will not help as i want for particular GKA which all regions persons has access only that the user should be able to see.
if i login as Reddy then he should be able to see:
Abott LA only not any other values
krishma ,
As per my understanding, the below will work.
Apply the Userprincipalname() filter on both User and Region details and User details as per account tables.
Then the above two tables to be connected to the sales table such that they filter the sales table
Just that you will have to be a little innovative in how the control gets passed from Security table to the other tables
Regards,