Forum Discussion
Post PatronDataflow refresh on simple queries extremely slow
Post PatronThe funny thing is that when I click refresh on some Dataflows, the 'LAST REFRESH' timestamp is almost instantly updated, but the refresh keeps spinning, and after the spinning stops (3+ min), the 'LAST REFRESH' timestamp is updated again.
Btw, the refresh of the simple Dataflow mentioned by me now takes up to 5 min sometimes.
Ridiculous. Should be 5 seconds max.
v-joesh-msftSolution Sage
Hi 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.- richard-powerbi
v-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.