Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ahwanmishra
Regular Visitor

Power BI API - Retrieving Latest Dataflow Refresh Status

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.

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

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...

 

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Super User
Super User

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...

 

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.