Currently, there is no way to get the actual refresh schedules of dataflows through the API. It is very important to see the coordination of dataflow and dataset refresh schedules. This seems like an overdue API option.
Can we please get this for dataflows, directly or through $expand?
I would assume it would be the same as datasets, just swapping out "datasets" for "dataflows" in the url.
We need: https://api.powerbi.com/v1.0/myorg/dataflows/{dataflowId}/refreshSchedule
If you want to take this a step further, would it be possible to include refresh schedules somehow into an $expand on GetGroupsAsAdmin? Or at the least an $expand option on the Get Dataflows? (Then do the same to $expand on the Get Datasets).
We can get the lists of datasets and dataflows by $expand on GetGroupsAsAdmin, but in order to keep the API Looping to a minimum, if we could expand additional details like Users/Access and Refresh Schedules off of this $expand of Groups, that would be a game changer.
5 Comments
Yes please add this, as it is crucial for monitoring.
- Status added:New
TobiaszAdvocate I
+1. We are trying to shift to dataflows in order to reduce hits to our SQL Server and to centralize transforms, but it was disappointing to realize this lack of feature parity with semantic models. We report heavily on semantic model refresh schedules via the Power BI REST API - now that we are shifting some of the data load onto dataflows, we need similar reporting functionality for dataflows.- This is still a desired feature. The best we can currently do is to query the transactions and see if there was a recent refresh on a schedule. Please bring the functionality from datasets/{datasetId}/refreshSchedule to dataflows.
TurkaKrisAdvocate II
+1 Definitely needed. To be honest it is surprising that some really basic apis are not available.
