Dataflow execution limits?

[bob32]

Hi,

Is there a limit on how long a dataflow (custom query) can take to execute? I need to load data from a heavily rate-limited API (100 records per request, once a minute) so the run time is  quite long (30+ minutes).

Thanks

[v-xicai · Accepted solution]

Hi @bob32 ,

If you are the Power BI admin, you can configure the dataflow workload in a premium capacity, see more: https://docs.microsoft.com/en-us/power-bi/service-admin-premium-workloads#dataflows.

You may need to improve the dataflow performance: https://community.powerbi.com/t5/Service/SQLServer-performace-issue-will-dataflows-help/td-p/783770.

Or use incremental refresh for dataflow, see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.