Fabric Rest API - How to get dataflow refresh history ?

[Datartine]

Hello,

I'm currently working on Fabric Rest API in Fabric notebooks.

I successfully got semantic models refresh history using Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn but I'm struggling to get dataflows refresh history...

Is there any way to get that refresh history ?

Thanks !

[Datartine]

Hi @wardy912 ,

Thanks for your answer. Dataflow transactions seems to solve my problem !

About FUAM, I noticed it but I didn't give it a try, because I'm a bit scared about its CU consumption. Is there any information about that ?

[wardy912]

Great news! I don't know about the CU consumption so it must be minimal as I haven't received any alerts! It gives us so much information that it's definitely worth a look. Highlighted a pretty serious vnet issue for us as soon as we installed it and took around 30 mins to install.

[wardy912 · Accepted solution]

Hi @Datartine 

 You could use the following (only returns limited metadata unfortunately)

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/transactions

Dataflows - Get Dataflow Transactions - REST API (Power BI Power BI REST APIs) | Microsoft Learn

For more detailed information, you will need to manually download a csv of the required refresh within fabric.

workspace - dataflow - refresh history then click the following

Not a great solution.

You could also use power automate if you have premium licensing but there's a fair bit of work that will go into that.

If you really want something great, install FUAM. It gives a lot of information on your fabric environment including 'refreshables details'. It's not too difficult to install and will help you out with other items in the future.

https://youtu.be/CmHMOsQcMGI?si=Xqsue0s044HQxJXn

https://youtu.be/G_-N2VMO8C0?si=JGyCC_dftsIdkzZb

I hope this is helpful, please give a thumbs up and mark as solved if it is, thanks!