Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.