Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |