Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi All
I have brand and Country columes in Row level sequrity table
my requriment is now abc4@gmail.com in brand colume have value as All,now abc4@gmail.com should get access for All brands (Ex:abc4@gmail.comshould get access for 3 brands Bajaj,Vespa&Honda)
DAX used to impleament RLS in my dataset
NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[Brand],RLS[Email ],userprincipalname())))
can any one help me on this
Thanks
Sriram.K
Solved! Go to Solution.
Hello
has the solution for this.
I've created a new columume like New_Column "All." used that column in the Row Level filter.
DAX used as row-level filter
NOT(ISBLANK(LOOKUPVALUE(RLS[Country],RLS[Country],[New_Column],RLS[Email ],userprincipalname())))
||
NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[brand],RLS[Email ],userprincipalname())))
Hi @Sriram_K
Could you tell me if your problem has been solved? If it is, kindly share your way or the reference material with us. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table or share me with your pbix file from your onedrive for business.
Best Regards,
Rico Zhou
Hello
has the solution for this.
I've created a new columume like New_Column "All." used that column in the Row Level filter.
DAX used as row-level filter
NOT(ISBLANK(LOOKUPVALUE(RLS[Country],RLS[Country],[New_Column],RLS[Email ],userprincipalname())))
||
NOT(ISBLANK(LOOKUPVALUE(RLS[Brand],RLS[Brand],[brand],RLS[Email ],userprincipalname())))
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @Sriram_K
If you don't set RLS, the user can see all table Brand values. Please provide me with more details about your table or share your pbix file with me.
And show me your problem and the result you want.
I hope the blogs about RLS can help you, links are as below:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://community.powerbi.com/t5/Service/RLS-for-default-Value-Show-all/td-p/231465
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
92 | |
91 | |
84 | |
81 | |
49 |
User | Count |
---|---|
145 | |
142 | |
111 | |
71 | |
55 |