Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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