Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
karihsantos
Regular Visitor

How to Access the Data Storage of the Fabric Metrics App

Hello!


I would like to know if it is possible to access the tables used by the Fabric Metrics App to store a history of data in another storage.

Any help would be appreciated.

1 ACCEPTED SOLUTION

You need to write a PowerShell script using these APIs

https://learn.microsoft.com/en-us/rest/api/power-bi/

To extract and save the logs in csv or JSON format somewhere then use Power BI desktop to connect to them files and build reports 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

3 REPLIES 3
aj1973
Community Champion
Community Champion

Hi @karihsantos 

Yes you can use PowerShell and Power BI Rest APIs to extract and save the logs in JSON or csv formats.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hello, @aj1973

Thank you for your response.

 

Could you please provide more details about this solution? I'm a bit confused about how to apply it.

You need to write a PowerShell script using these APIs

https://learn.microsoft.com/en-us/rest/api/power-bi/

To extract and save the logs in csv or JSON format somewhere then use Power BI desktop to connect to them files and build reports 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.