The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
When I run a usage matrix report its only holding 30 days' worth of data, I've read that Power BI used to be able to return 90 days but only now it's 30 days?
I've read it's possible to export the Usage Metrix report data every day so we can build up some historical data to report on, but I've not found a working example on how to set this up.
Has anybody tested recently exporting the usage matrix report to a Blob storage, or any other way?
I hope someone can point me in the right direction, thanks in advance.
Setting up an automated export process for Power BI usage metrics data involves using Microsoft Power Automate. Follow these steps to create a flow that exports usage metrics data on a regular basis:
Access Power Automate:
Create a New Flow:
Choose a Trigger:
Configure the Trigger:
Add an Action to Export Data:
Configure the Export Action:
Save and Test:
Set Up Storage Destination (Optional):
Turn On the Flow:
Monitor and Troubleshoot:
If you find this insightful, please provide a Kudo and accept this as a solution.