Power BI Report Usage Data

[vmichaels]

Hello, 

As a part of my responsibilities, I need to collect data of Power BI report usage across multiple workspaces. I am an admin in all of them but I am not a Power BI Administrator. I can not use Admin APIs. How can I get Power BI usage data? My ideal solution is to pull the report usage data from 20 workspaces and ingest this data into Kusto database. It would be nice if that data is in Kusto database already. 🙂

[V-lianl-msft · Accepted solution]

Hi @vmichaels ,

You need to set up in order to get this solution working:

Azure AD Global Admin account
Azure AD Application - to help us authenticate to the O365 Management APIs
Power BI Streaming Dataset - to hold the Power BI activity logs

For more details,please refer to:

https://www.proserveit.com/blog/power-bi-usage-metrics-across-all-workspaces 

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

[Hariharan_R]

Hi,

  As you know you can get the reporting usage metrics for each workspace which will show the usage stats of that particular workspace. if you need anlayze from one place for all the 20 workspace then I would suggest check with Admin and see whether they are maintaining the logs in any database. If yes then you can get access to those database query it.

Thanks

Hari