Forum Discussion

blancagutierrez's avatar
blancagutierrez
New Member
2 years ago

Export Users List

Hello PowerBI community,

I hope this message finds you well. I'm currently working on a project and am curious to know if there's a way to export a comprehensive list of all users who have access to a specific dashboard in PowerBI (see below, list from File/Manage Permissions/Direct Access).

I've noticed that the "Report Usage Metrics" provides information about users who actively use the dashboard, but I'm specifically looking for a way to export a list of all users with access, including those who may not be frequent users. It's worth mentioning that our dashboards are not organized within apps.

Any insights or guidance on achieving this would be greatly appreciated. Thank you in advance for your help!

 

 

 

Custom Export
Excel Export
Export
Export data to CSV
user management
User Management in Report Server

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi blancagutierrez ,

    You use the PowerBI API or Azure Portal to extract all PowerBI users and workspace access.

    First change the username and password for your PowerBI credentials. The script collects the results and then opens two Out Grid windows (Workspaces and Workspace Users). You can then copy/paste the grid results into excel. This doesn't export shared reports and dashboards.

    Below is the relative link will help you:

    How to extract all PowerBI users and workspace access using the PowerBI API or Azure Portal? - Stack Overflow

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.