How to view a list of a single user's access to dashboards?

[Anonymous]

Hello everyone,

We have multiple workspaces, power BI apps.
each workspace have multiple dashboards.

How to get the answer If we need to check a single user, of how much and which dashboards/report he/she has access to?

Currently we are rolling through all the dashboards we currently have and apparently it is not an idea way.

Thanks in advance!

[amitchandak]

@Anonymous , Not pretty sure on that but in usages analytic might have some option

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics

[Anonymous]

Hi...it still relies on go to each dashboard and pull the metrics.
Also some user like exec may not look the dashboard twice a year but all of them need to be kept in the list.

[v-yingjl]

Hi @Anonymous ,

You can use PowerShell to get the list of dashboards about current user.

If you never use PowerShell before, you need to install power bi module:

1. Run PowerShell ISE

Firstly, start PowerShell ISE as an administrator. The Windows PowerShell Integrated Scripting Environment (ISE) is the host application for Windows PowerShell. In ISE, you can run commands and write, test, and debug scripts in a single Windows-based graphical user interface.

2. Install module.

In order to manage the connection to Power BI Service, we need to install “MicrosoftPowerBIMgmt”. We can use the visual interface of PowerShell ISE to add this module, or use the command to add. Please refer to the link.

Power BI Cmdlets reference | Microsoft Docs

Now we can start writing the Power BI PowerShell script:

Connect-PowerBIServiceAccount
$Dashboard = Get-PowerBIDashboard
$Dir = "C:\Users\xxx\Desktop\dashboard.csv"
$Dashboard | Export-Csv $Dir -NoTypeInformation -Encoding UTF8
Disconnect-PowerBIServiceAccount

Tips:

The path in $Dir variable is depending on yourself where you want to store the dashboard list, currently it can only be stored as .csv format

When running this script, it will export the list of power bi dashboard of the user who you are entering the credentional to connect to a .csv file to the corresponding path:

In addition, you can refer this blog about using PowerShell with power bi: Working with PowerShell in Power BI 

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

[Anonymous]

+---------------------+-------+
| Sales Dashboard | Tom |
+---------------------+-------+
| Material Dashboard | Jerry |
+---------------------+-------+
| Material Dashboard | Morty |
+---------------------+-------+
| Inventory Dashboard | Rick |
+---------------------+-------+

[Anonymous]

Hello @v-yingjl 

Hi, it does not look like the end user list.

I am looking at the shared access of each report. Ideally something like this:
+---------------------+-------+
| Sales Dashboard | Tom |
+---------------------+-------+
| Material Dashboard | Jerry |
+---------------------+-------+
| Material Dashboard | Morty |
+---------------------+-------+
| Inventory Dashboard | Rick |
+---------------------+-------+

Is there an API for that in PowerShell ?

[v-yingjl]

Hi @Anonymous ,

As far as I know, currently PowerShell seems has no corresponing command to get a dashbaord access for users because PowerShell needs to connect to PowerBI service account firstly for each user then get information from service.

Perhaps you can create a new idea here to help us improve power bi and make this feature coming sooner.

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