Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report Usage report

Looked at the view metrics report for a customer for the first time today.   The old version returns data for the correct date range. It does not return all the data the client wants.  So I switche...
Need Help
ibarrau's avatar
ibarrau
Super User
4 years ago

Hi SqlBobScot. It sounds like if you have the usage report broken and you can get support, you might have to build it from scratch. That's an amazing option to get a better user experience, but it will take time.

If you are the admin, you can register an app at azure in order to use the Power Bi Rest API. In there you will find this request: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

That one will return the activity events used for the usage metrics report. You can return day by day for the tenant, all workspaces, all reports, etc.

You probably need to write same code and store that on a DB to build a robust and scalable base of activities. You can find cmlets with powershell or libreries like SimplePBI with python to help you use the API.

You can also write an issue to the community if you can't rise a ticket to support. They might help there:

https://community.powerbi.com/t5/Issues/idb-p/Issues

I hope that helps,