Dynamic Row level security help

[Anonymous]

HI,

I have data like below for orders table and roles table.
Roles table:

Orders table.

Now Orders tables has 3 countries, US, UK, canada and Roles table has which country data accessed by which user.

Now based on user login to the report Orders table data has to be filtered with RLS.

How to do that?

As of now i dont have any relationship between these 2 tables.

Kindly help
@needhelp   @Pragati11 @MFelix @amitchandak   @GilbertQ @lbendlin @Greg_Deckler 

[Pragati11]

Hi @Anonymous ,

You can refer following articles on how to approach Row-level security in Power BI:

https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

https://www.sqlshack.com/introduction-to-row-level-security-in-power-bi/

Thanks,

Pragati

[Anonymous]

@Pragati11 Hi Pragati provided links will not help to my situation.

Here i would like filter dataset based on login user in Dynamic way with RLS.

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

I suggest you unpivot you role table and filter it to yes :

And create  a relationship between your order table and role table by  Attribute column and Country column. Then follow the steps in https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple to create dynamic rls.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai