Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
please follow the below blogs to get dataflow refresh details :
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
please follow the below blogs to get dataflow refresh details :