User Access

[PujaJoshi]

I have created a report in Power BI. Now need to give user acess for eg.

1. Specific users will have access to all reports.
2. Specific users on each project will have access to this report.
3. The person who is working on the project will select the reporting period to generate the report.

How to customise acess to users on same report depending on the department?

[Greg_Deckler]

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.

[PujaJoshi]

Thank you for the solution. Can you please explain it in details from where I can get these options.

[Greg_Deckler · Accepted 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

[PujaJoshi]

Thank you