Export Users List

[blancagutierrez]

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!

[Anonymous]

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...

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.