Get Dataflow Refresh Schedule from Power BI REST API

[AnthonyMCUBI]

Hi everyone,

I'm using the Microsoft.PowerBi.Api Nuget package in my C# project, and I'd like to receive my dataflows' refresh schedules using that package's API. I see that it is possible to retrieve refresh schedules for datasets, but I don't see a similar action for dataflows. Is this possible at the moment, and if not, is it planned for the future?

Link to REST API Dataset - Get Refresh Schedule endpoint.

Link to Microsoft.PowerBi.Api Github repository.

Thank you,

Anthony

[dbeavon3]

Has anyone figured out how to retrieve the refresh schedule? 

It seems like there should be a better level of consistency between datasets and dataflows.  I'm definitely spending a lot of time spinning my wheels on the dataflow API.

[dchaillar]

If you have permission for it, there is an admin api call that will get you the refresh schedule and average duration for anything that is refreshable within a Capacity (only for datasets/flows in premium in some capacity): 

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshables

Otherwise you'd need to use data from get-dataflow-transactions and infer scheduled refresh times
https://learn.microsoft.com/en-us/rest/api/power-bi/dataflows/get-dataflow-transactions

[pbi_champ]

This is wrong information.  The Admin - Get Refreshables endpoint returns only dataset refresh schedules, not dataflows. 

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshables

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshable-for-capacity#refreshableki...

[v-easonf-msft]

Hi， @AnthonyMCUBI 

All related API have be list here.

https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows 

Have you checked this?Does it work？

Dataflows - Update Refresh Schedule 

Best Regards,
Community Support Team _ Eason

[AnthonyMCUBI]

Hi @v-easonf-msft ,

I did see the linked Dataflow REST API, but did not find an appropriate function for my purpose. I did test UpdateRefreshSchedule, but it does not allow me to receive the current refresh schedule configuration so it isn't a solution to my issue.

Regards,

Anthony

[frano72]

Hi @AnthonyMCUBI - did you manage to find a way to return the configured refresh schedules ?

[v-easonf-msft]

Hi, @AnthonyMCUBI 

It is recommended to create a support ticket in Power BI support for further help.

https://powerbi.microsoft.com/en-us/support/ 

They may know  other workarounds.

Best Regards,
Community Support Team _ Eason