Forum Discussion
Using RLS with Dynamic filter
I needed some help with the RLS in my model. Trying to set up RLS on my dimensions so that it gets filtered in to the transaction as well. But, i was I have 2 dimension table with Products ...
Hi Anonymous ,
I updated your sample pbix file, please check whether that is what you want.
1. Create relationship between table Users and Products
2. Create a role for the table Users with the formula as below
[PrincipalName] =USERPRINCIPALNAME()3. Test role
In addition, you can refer the content in the following links to get it.
Dynamic Row Level Security with Power BI Made Simple
Best Regards
Hi Anonymous ,
I updated your sample pbix file, please check whether that is what you want.
1. Create relationship between table Users and Products
2. Create a role for the table Users with the formula as below
[PrincipalName] =USERPRINCIPALNAME()
3. Test role
In addition, you can refer the content in the following links to get it.
Dynamic Row Level Security with Power BI Made Simple
Best Regards