Dynamic RLS Based on Region, Country

[Raman3456]

Dear All,

I have one data like 

username  market    market unit

abcd          USA         Newyork

bcde          India        Delhi

Need to apply RLS based on the criteria like     ---- Raman ( Userprinciplename) && dynamic market value && Dynamic Market unit .

Will it be possible ?

Thanks for the support.

[Anonymous · Accepted solution]

@Raman3456 

To set Dynamic RLS, you need to have their power bi account in a column.

For example:

Username	Market	Market Unit	Email address(pbi account)
Raman	AUS	Sydney	Raman@microsoft.com
Ashok	US	NewYork	Ashok@microsoft.com

1. In the RLS, create a role: Email address = userprinciplename()

2. Publish to service, in Security tab add all emails(pbi account) to the role

3. With the above setting, users log into power bi service will only see data in the respective rows.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Migasuke]

Hi,

please can you show your model?

[Raman3456]

Hi