cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Export List of App "Users"

What about if you want to download the list of users that are access the report online on the Power Bi server? How do you do that?

Highlighted
Frequent Visitor

Re: Export List of App "Users"

While this did extract the information, all of my names, email addresses and persmissions were concatenated without a delimiter. I was able to extract the emails manually for a small number of users (around 300) so was able to complete the task I needed to do but this is a major flaw with PowerBi that needs to be rectified.

 

Extracty the list of users should work exactly the same way the user statistics are extracted.

 

 

Highlighted
Helper I
Helper I

Re: Export List of App "Users"

There is no other solution than the proposed by @MrSun ?

What if we have ten published application?

 

I Have done a PowerShell script to export all the workspaces with all his members, but I would like to add some code to export the members who have access to the applications.

 

It doesn't exist an HTTP request like "Get Group Users" but with applications instead of workspaces?

 

Thanks.

Highlighted
Advocate II
Advocate II

Re: Export List of App "Users"

If you were really organised you could do this via AD groups, at least for apps that you restrict.  I'm neither that organised nor are all our apps restricted.  So this is what I've done....

 

This ends up giving you a list of users of the reports that are published in the app, rather than all the app users who have access, but if you want to communicate to the users who use it, this gives you that ability; it also gives you that same ability for non-restricted apps which don't have a defined user list.

 

  1. On any report in the app's workspace create one of those "View usage metrics report" reports.
    That will give you info about one single report.  Nice, but not that useful.
  2. Click on File then Save As to create a copy of that generic useage report.
    Personally I name these, e.g. "Report Usage (Workspace Name)".
    (Sometimes I get an error message telling me that report doesn't exist, but when I go back to the workspace the report is there.)
  3. You can then edit that report, in particular you can:
    1. Remove the filter so all reports are shown
    2. Make it your own report

      This is what mine looks like:
      Workspace Useage Report ExampleIt's got a report filter in the top left, and a table of users in the bottom right. 
  4. You can then export the data in the table with the users' email addresses in it.

 

Presumably you can do the same with Dashboards in a workspace; I haven't had that need.

 

I'm also guessing there must be an easier way to this, e.g. via whatever Tenant Admin's have access to, but this is the best I can do with the access I've got.

 

Hopefully that's useful to someone.

 

Highlighted
Frequent Visitor

Re: Export List of App "Users"


@Steve_Bedford wrote:

If you were really organised you could do this via AD groups, at least for apps that you restrict.  I'm neither that organised nor are all our apps restricted.  So this is what I've done....

 

This ends up giving you a list of users of the reports that are published in the app, rather than all the app users who have access, but if you want to communicate to the users who use it, this gives you that ability; it also gives you that same ability for non-restricted apps which don't have a defined user list.

 

  1. On any report in the app's workspace create one of those "View usage metrics report" reports.
    That will give you info about one single report.  Nice, but not that useful.
  2. Click on File then Save As to create a copy of that generic useage report.
    Personally I name these, e.g. "Report Usage (Workspace Name)".
    (Sometimes I get an error message telling me that report doesn't exist, but when I go back to the workspace the report is there.)
  3. You can then edit that report, in particular you can:
    1. Remove the filter so all reports are shown
    2. Make it your own report

      This is what mine looks like:
      Workspace Useage Report ExampleIt's got a report filter in the top left, and a table of users in the bottom right. 
  4. You can then export the data in the table with the users' email addresses in it.

 

Presumably you can do the same with Dashboards in a workspace; I haven't had that need.

 

I'm also guessing there must be an easier way to this, e.g. via whatever Tenant Admin's have access to, but this is the best I can do with the access I've got.

 

Hopefully that's useful to someone.

 


but this would only report the list of users who access the report, not all the users who have access the report right?
but this

Highlighted
Microsoft
Microsoft

Re: Export List of App "Users"

@ruanolinHow did you manage to pull out members info along with the workspaces export. Also, did you get to export the list of users that have access to reports/dashboards specific to them in the workspace? Please let me know as I'm trying to figure out on pulling the access permissions for various users for each report/dashboard in a set of workspaces.

BR,
mamidi

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors