Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi community, I need one quick help with RLS. I am trying to create heirarchy for RLS between zone and respective country. But i am getting the below error. can someone guide what should i do to remove it. thanks in advance.
Solved! Go to Solution.
Hi,
It is because the data in [Zone] and [Country] can not correspond with each other due to lack of 'US' in [Zone] in this case.
And please try this column:
Column = 'Table'[Zone]&"-"&'Table'[Country]
The result shows:
Best Regards,
Giotto
Hi,
It is because the data in [Zone] and [Country] can not correspond with each other due to lack of 'US' in [Zone] in this case.
And please try this column:
Column = 'Table'[Zone]&"-"&'Table'[Country]
The result shows:
Best Regards,
Giotto
Okay thanks..this worked..but please also can you tell me how to apply filter for where country is ALL.... if country =all then i must get all the countries against that user...and also if a user is tagged to one single country then that user must be able to see only that country under that zone when he logins..thanks
@Anonymous not actually sure what you are trying to achieve.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I want to create heirarchy column to acheive dynamic RLS. on the basis of this column i will create role so that when a user logins he or she will only be able to see the zone and country for which he or she is supposed to.. hope this helps
@Anonymous I don't thin you need hierarchy to achieve this, you can create any business logic in RLS , read my post here that talks about how you bring your business logic to RLS.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Could you please guide me what should i write in the rls statement so that it gives me data accordingly to the excel. as you can see for the second last it should give me only US country under NA zone and for the last user it must give me all the data. it should bifurcate the data accordingly.