Forum Discussion
Post PatronDataflow refresh on simple queries extremely slow
Solution SageHi richard-powerbi ,
According to my experience, the minimum refresh time of dataflow is designed to be 30s, but I can't find related documents at present, if I find it, I will update it here.
However, I think this does not affect the use of dataflow. When you get data from dataflow using Power BI Desktop, and then publish to power bi service, you will find that the dataset refresh will be fast.
For more information, you can refer to the following article:
How to Use Dataflow to Make the Refresh of Power BI Solution FASTER!
Regarding Blank Query doesn't give the notification that it doesn't need a gateway, It is also by design.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Patronv-joesh-msft thx for the reply, but isn't it even at a lower level, 30 sec per query, and not per dataflow? Because if it was at dataflow level, my tiny dataflow would refressh in 30-35 sec or so....
- v-joesh-msft
Hi richard-powerbi ,
Yes, you are right, maybe what I described is not very accurate. The minimum time for a query refresh is designed to be 30s, so the minimum time for a dataflow refresh is 30s.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- richard-powerbi
"so the minimum time for a dataflow refresh is 30s"
I believe you make the same mistake again.. 😉
According to my testing, that's the minimum per query. So if a Dataflow has 6 queries, no matter how tiny they are, the Dataflow refresh is 3m min.