How to give access for a dashboard with two different privileges in Power BI?

[pirinthan14]

as a example, I have list of US states and cities
I want to show “TN, OR, LA” states when User A opens the dashboard, for everyone else, all states need to be shown.

No idea to do this .I am using 30 days trial Power BI desktop

[AlexChen · Accepted solution]

Hi @Pirinthan,

For example, you have table “stateTable” in powerbi desktop.

You can follow the steps below to config row level access to your table.

1. create roles by clicking “Manage roles” in powerbi desktop.

2. click “create” to create roles, here I create 2 roles,

role1 can only see data of state “TN”, “OR”, “LA”

role2 can see all of the states.

Then click “Save” to save your setting.

3. create a report and publish it to service.

4. go to service and find your dataset, click “…”,  then click “SECURITY”,

5. You will see page below with 2 roles there. Role1 can only view state “TN”, “OR”, “LA”. Role2 can view all states just the same with what you configured in powerbi desktop above. Add members to role1 and role2.

6. Share you dashboard to the members in role1,  then login in with the members to powerbi service.

You will find that the members can only see state “TN”, “OR”, “LA”.

7. Share you dashboard to the members in role2,  then login in with the members to powerbi service.

You will find that the members can view all states.

[AlexChen]

Hi @Pirinthan,

You can use Dynamic Row Level Security to do this. 

You can do configuration in database to control the content that a user can see from dashboard.

For more details, you can see https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-row-level-security-onprem...

Best Regards

Alex

[pirinthan14]

Thanks @AlexChen