Forum Discussion
Fabric Rest API - How to get dataflow refresh history ?
Hello,
I'm currently working on Fabric Rest API in Fabric notebooks.
Hi Datartine
You could use the following (only returns limited metadata unfortunately)
https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/transactionsDataflows - 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!
3 Replies
Hi Datartine
You could use the following (only returns limited metadata unfortunately)
https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/transactionsDataflows - 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!
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.
