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.
I have created a report in Power BI. Now need to give user acess for eg.
How to customise acess to users on same report depending on the department?
Solved! Go to Solution.
Workspace:
In the Service, Workspaces | Create app workspace. Navigate to the workspace. Use the Access link to assign access. Members can read, Contributors can read, edit and create new reports, etc. Admins can do all of those things and assign permissions.
Reports:
Publish reports to your new workspace. Navigate to report. Use the Share option in the upper-right to share the report with others.
RLS:
In the Power BI Desktop file, use the Modeling tab | Manage Roles to create roles. Once published to the service uses the ellipses next to a report in the left-hand navigation and go to Security to assign people to roles:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Sounds like you need a Workspace and people you assign at the Workspace level will have access to all reports in the Workspace. You can assign individual people to access to specific reports at the Report level (sharing). You could use Row Level Security (RLS) to provide even more granular control so that certain users can see some information in a report but not everything in the report.
Thank you for the solution. Can you please explain it in details from where I can get these options.
Workspace:
In the Service, Workspaces | Create app workspace. Navigate to the workspace. Use the Access link to assign access. Members can read, Contributors can read, edit and create new reports, etc. Admins can do all of those things and assign permissions.
Reports:
Publish reports to your new workspace. Navigate to report. Use the Share option in the upper-right to share the report with others.
RLS:
In the Power BI Desktop file, use the Modeling tab | Manage Roles to create roles. Once published to the service uses the ellipses next to a report in the left-hand navigation and go to Security to assign people to roles:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Thank you
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.