Unanswered

Grant access to PowerBI Dahsboard with Power Automate

(0) Share

Report

Posted on by Berry26

Dear Community

Is it possible to setup a workflow to grant access to a PowerBI dashboard with power automate.

The goal would be for the user to request access, have them accept the T&C and then be granted access to the dashboard.

BR
Berry26

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Berry26,

Are you using classic or new workspaces?

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-manage-app-workspace-in-power-bi-and-office-365

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-give-access-new-workspaces

When you are using new workspaces you should be able to add the member to the related office 365 group. After that the membership will sync up to the workspace.

From a flow that would be this single action.

https://docs.microsoft.com/en-us/connectors/office365groups/#add-member-to-group

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, do you know if I can also choose the permissions that the user will have inside the dashboard? Example: I have a dashboard with 2 pages: one with financial data and other with estructural data. I want to grant access only to financial page to the person who belong to financial team.

Was this reply helpful? Yes No
javier-martinez 2 on at

Like (0)

Report

Hi @Anonymous, you have to apply the Row Level Security first, to grant access depending on the person.

Was this reply helpful? Yes No
LV-29010109-0 2 on at

Like (0)

Report

Hi, at present you cannot provide / limit permissions to a page in a report. You can only limit access to the whole report (access permissions on the report itself), or limit access to data inside the report (row level security in the datamodel that the report connects to). If you have the need to hide some pages from some users you will need to create a copy of the report, delete the pages the users must not see and then provide the users with access to this "sibling" report. I've needed to do this frequently with a "Management" version of a report and a "Standard user" version of the report where management gets different dashboards and analytics to that provided to a standard user, but the 2 versions of the report shares many pages. I usually create the management report first. Then create a copy of it and tailor the 2nd version to the standard user needs. Then provide access to both reports using AD user groups and row level security in the data model.

Was this reply helpful? Yes No