Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
Hi @Anonymous ,
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.
Hi @Anonymous ,
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!