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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
onerbreno
Frequent Visitor

How to save more than 14 days of history from the Fabric Metrics App?

I’m looking for a way to save the dataset from the Fabric Metrics App to a data lake or some storage, but I’m having trouble doing so. Any suggestions on how to accomplish this?

Thanks!

1 ACCEPTED SOLUTION
onerbreno
Frequent Visitor
5 REPLIES 5
onerbreno
Frequent Visitor
v-zhengdxu-msft
Community Support
Community Support

Hi @onerbreno 

 

Could you tell me if your problem has been solved?

If it is, kindly Accept it as the solution. More people will benefit from it.

Or you are still confused about it, please provide me with more details about your problem.

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aj1973
Community Champion
Community Champion

Hi @onerbreno 

You can use PowerShell and Power BI rest APIs to extract and save logs in JSON or csv formats then you build your report with Power BI 

 

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

Hi @aj1973 

Thanks for your response!

I am using the Power BI REST API for Execute Queries and managed to retrieve some tables. However, there are others that it returns as empty, even though they actually contain data. Can you help me with this?Captura de tela 2024-08-01 162102.png
Another point as well, is there a way to list all the tables in the dataset?

Hi,

 

Yes, you can use this in the Query:

EVALUATE INFO.TABLES()

 

This will return all tables in a model.


Br
Marius
BI Fabrikken
www.bifabrikken.no

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors
Users online (1,229)