Forum Discussion
Storing/exporting Usage Metric Report Data
Hi all,
I've built my own PowerBI report. linking to the usage metric data in the PowerBI service, but we really need to see our trends back more than 30 days.. I'm wondering if anyone has found a way to export/store/append Usage Metric Data so you can look at historical trends further back than what is currently stored?
thanks
sarah
Hi. If you want to take more data you need to develop the report instead of using the automatic by microsoft. There are two ways to obtain logs for usage metrics. One of them can get 90 days of data instead of 30, but it's more difficult to automate in my opinion. That would be exporting audit logs. The other way just gets 30 days data from PowerBi Rest API.
The best way to have even more data is using one of those two and store the data every day so you can build your history in a storage (e.g. data lake gen2, blob, sql database, etc)
You can read more about those two ways in the following doc:
https://learn.microsoft.com/en-us/power-bi/admin/service-admin-auditing
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hey, Since you already have a report created w.r.t usgae metrics, you can leverage the Power BI REST API to extract data.
The below blog explains :
https://datasharkx.wordpress.com/2022/11/03/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-via-managed-identity-authentication-part-4/
https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-1/API:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries
Hi. If you want to take more data you need to develop the report instead of using the automatic by microsoft. There are two ways to obtain logs for usage metrics. One of them can get 90 days of data instead of 30, but it's more difficult to automate in my opinion. That would be exporting audit logs. The other way just gets 30 days data from PowerBi Rest API.
The best way to have even more data is using one of those two and store the data every day so you can build your history in a storage (e.g. data lake gen2, blob, sql database, etc)
You can read more about those two ways in the following doc:
https://learn.microsoft.com/en-us/power-bi/admin/service-admin-auditing
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
