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

[onerbreno]

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!

[onerbreno · Accepted solution]

sempy.fabric package | Microsoft Learn

[v-zhengdxu-msft]

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]

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 

[onerbreno]

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?
Another point as well, is there a way to list all the tables in the dataset?

[mariussve1]

Hi,

Yes, you can use this in the Query:

EVALUATE INFO.TABLES()

This will return all tables in a model.