cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
glenncogar Frequent Visitor
Frequent Visitor

User access review for Power BI reports

My organisation would like to implement regular 'user access reviews' (as part of our governance on usage) on:

 

- content (reports, etc) published to the Power BI service, and

- who that content has been shared with (and ideally role for sharing e.g. member, admin)

 

periodically, we would like to be able to produce a list of published content and ask the publishers of that content to review who it is shared with and confirm that the sharing is appropriate/up to date.

 

Is there a way of doing this on a 'global' level? i.e. list all published content and who it is shared with?

 

I have seen the 'usage statistics' for individual reports (that I have published and shared) which tells me the data is there but I can't find an easy way of accessing it and creating my own report and I also cant see an easy way of doing it for all published content (including stuff that's not my own).

 

I am also aware there is a log but I understand this is really only showing 'access events' rather than what has been published and who it is shared with.

 

I'm guessing that Power BI keepts the data for:

- published content

- sharing

- content access

- etc.

 

in some underlying 'service' data and I hope there is an easy (API? service layer?) for getting access to this data and running our own governance reports/ creating our own governance dashboards.

 

Any suggestions welcome 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
v-danhe-msft Super Contributor
Super Contributor

Re: User access review for Power BI reports

Hi @glenncogar,

 

You can use Power BI reports and dashboards API to list dashboards and reports: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreportingroup

 

But currently there is no rest API to list shared users for each dashboard or report. You can go to Audit Log and search share dashboards/reports activities, find shared user by clicking each activity. 

 

Reports - Get Report In Group (Power BI REST APIs ...

docs.microsoft.com

Returns the specified report from the specified workspace. Required scope: Report.ReadWrite.All or Report.Read.All To set the permissions scope, see Register an app.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-danhe-msft Super Contributor
Super Contributor

Re: User access review for Power BI reports

Hi @glenncogar,

 

You can use Power BI reports and dashboards API to list dashboards and reports: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreportingroup

 

But currently there is no rest API to list shared users for each dashboard or report. You can go to Audit Log and search share dashboards/reports activities, find shared user by clicking each activity. 

 

Reports - Get Report In Group (Power BI REST APIs ...

docs.microsoft.com

Returns the specified report from the specified workspace. Required scope: Report.ReadWrite.All or Report.Read.All To set the permissions scope, see Register an app.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-danhe-msft Super Contributor
Super Contributor

Re: User access review for Power BI reports

Hi @glenncogar,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
glenncogar Frequent Visitor
Frequent Visitor

Re: User access review for Power BI reports

Thanks for your reply Daniel,

 

your description of how to access the facilities currently available in Power BI was very helpful.

 

Based on your reply, I think I need to suggest to Microsoft that there are some governance/admin features they need to provide so that organisations can govern the reports and dashboards published and shared.

 

I have not really used the API feautes of Power BI yet so I'll try them out to see how close I can get to what we need.

 

Thanks for your help.  I hope that others also find this useful.

 

For anyone looking for similar features, please vote for this.  If you know that someone else has already requested this feature please let me know by posting the link(s) back here.

ferdsjoseph Regular Visitor
Regular Visitor

Re: User access review for Power BI reports

@glenncogar Hi! Were you able to find a way to get the list of users whom reports have been shared with?

 

 

Regards,

 

Ferdinand

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 246 members 2,415 guests
Please welcome our newest community members: