Forum Discussion

Datartine's avatar
Datartine
Frequent Visitor
1 year ago
Solved

Fabric Rest API - How to get dataflow refresh history ?

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 RE...
  • wardy912's avatar
    1 year ago

    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!