Forum Discussion
Dynamic RLS in Power BI with duplicate values
Hi Swati20,
Perhaps you can create these mange fields on power bi side, you can create calculated table to append custom row from the raw table and use this new table to link other tables.
After these steps, you can setting additional if statement condition batch in RLS filter to check current role are include in the exception scenarios.Regards,
Xiaoxin Sheng
Hi Anonymous ,
Thanks for your response.
Actually, my main issue here is that Admins should have full visibility of the data but I'm not able to create Admin role for that since neither can I assign a single account to the Admin similar to the users nor can I assign "ALL" for all accounts as there is no "ALL" or blank values in the Account column of EmpTable .
Hi Swati20,
Perhaps you can create these mange fields on power bi side, you can create calculated table to append custom row from the raw table and use this new table to link other tables.
After these steps, you can setting additional if statement condition batch in RLS filter to check current role are include in the exception scenarios.
Regards,
Xiaoxin Sheng