Showing results for 
Search instead for 
Did you mean: 
aka Regular Visitor
Regular Visitor

to implement a security model

I have implement security model for following data structure.


Employee is sales rep and will only see his territory.Manager, and needs to see his own territory AND his Employee

I have tried creating roles and using Username() function on access as [access]=USERNAME() .

please give some suggestions. 


Microsoft v-huizhn-msft

Re: to implement a security model

Hi @aka,

1. You create a role by clicking manage roles->create a new role->type [Access]=USERNAME().

2. Select the View as roles to test if you create the role correctly.

3. Publish the report to Power BI service. Select the dataset->Security. Add the member, apply the role to him. Then share the dashbord to them. 

More details, please reference to the articles.

Row level security with Power BI Embedded

Row-level security (RLS) with Power BI


If you have other issues, please feel free to ask.

Best Regards,


Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)