Power BI API - Retrieving Latest Dataflow Refresh Status

[ahwanmishra]

Hello Community,

I'm encountering an intermittent issue with the Power BI API while attempting to retrieve the status of the last refresh for a specific dataflow. We use the following endpoint:

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/transactions/transactions?$top=1

Despite including the $top=1 parameter, we received the status of a dataflow refresh that wasn't the most recent.

This issue comes up occassionally and we have not identified a consistent pattern for it. Could someone provide insights into potential limitations causing this discrepancy?

Additionally, I'm looking for the most effective method to reliably retrieve details on the latest dataflow refresh.

[Anonymous]

Hi @ahwanmishra ,

The Power BI REST APIs have certain limitations. For instance, the refresh history isn’t returned for OneDrive. There are always between 20–60 available refresh history entries for each dataset, depending on the number of refreshes in the last 3 days. The most recent 60 are kept if they are all less than 3 days old. Entries more than 3 days old are deleted when there are more than 20 entries.
If a refresh fails, the data doesn’t update. Your data might be stale until the latest refresh completes, or you can refresh it manually and it can then complete without error.

Understand and optimize dataflows refresh - Power BI | Microsoft Learn
As for reliable Retrieval of Latest Dataflow Refresh Details,You can review the Refresh History on the dataflow settings page. This provides an overview of refreshes, including the run time, the refresh type, the duration, and the run status.

Three methods to get refresh history of Power BI d... - Microsoft Fabric Community

Best regards.
Community Support Team_Caitlyn

[NandanHegde · Accepted solution]

please follow the below blogs to get dataflow refresh details :

https://community.fabric.microsoft.com/t5/Community-Blog/Three-methods-to-get-refresh-history-of-Pow...