Forum Discussion

rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
4 years ago
Solved

Average time of Dataflow refresh

How long in average if you setup a Dataflow loading 400K rows all 53 columns?   I would like to know to compare mine (about 1.5 mins) to have an idea of baseline workload.   Thanks and best regar...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  rdnguyen ,

    Too many datasets to refresh at the same time occupy CPU and memory, Insufficient gateway or underlying data source performance (busy on network / refresh), To refresh the model to be loaded into memory, it takes up 2 times the size of the data set, and you need to wait for memory resources.

    If you feel slow when refreshing, you can consider the following actions:

     

    You can select the dataflow options (the ellipses next to the dataflow) and then select Cancel refresh. Or scheduled the refresh of dataset at different time.

    Understanding and optimizing dataflows refresh

    https://blog.crossjoin.co.uk/2021/04/18/power-bi-dataflow-performance-premium-per-user-and-the-enhanced-compute-engine/

     

    Best Regards,

    Liu Yang

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