Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape 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.

Reply
Sriram_K
Helper I
Helper I

RLS by Brand

Hi All

I have brand and Country columes in Row level sequrity table

Sriram_K_0-1595243098059.png


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

1 ACCEPTED 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())))


View solution in original post

5 REPLIES 5
v-rzhou-msft
Community Support
Community Support

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())))


@Sriram_K
Glad it's working! Please mark the answer as a solution so others can find it easily too and benefit.

Please @mention me in your reply if you want a response.

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

v-rzhou-msft
Community Support
Community Support

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. 

AllisonKennedy
Super User
Super User

Sorry, I don't understand your question. Can you provide a bit more detail and what you're tables look like? What's not working? What is your desired result?

Please @mention me in your reply if you want a response.

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.