How to Export Power BI Usage Data to Snowflake Daily for Custom Reporting

[kapildua16]

I want to extract usage metrics (such as report views, user activity, etc.) from my Power BI workspace without using the default Usage Metrics Report'. My goal is to automate the extraction of this data and store it in Snowflake on a daily basis, so I can build a Power BI report using Snowflake as the data source. What are the best ways to achieve this, and are there any examples or recommended approaches?

[v-pgoloju]

Hi @kapildua16,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @lbendlin and @Cookistador for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[lbendlin]

Is this only for your workspace?  The standard approach is to use the tenant audit logs, extracting daily JSON files.  This has to be done by a tenant admin account.

[Cookistador]

The api: Get Activity event is your friend for this kind of purpose:

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

You can use ADF or Powershell/Python script to push the data in a table which will use as landing area in Snowflake