Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My dataset has a scheduled update and taking 10-15 minutes to finish.
When I run on-demand update, it only takes 2-3 minutes.
Both updates go through the gateway.
Can someone help me?
Thanks,
Hi @PedroGomesANCD ,
Whether they are manually refreshed or scheduled to be refreshed, their process is the same. Only, the start time and the actual time of the scheduled refresh are not the same. And the power bi service ensures user interaction first when there is not enough memory, and starts refreshing data only when there is enough memory. And the network factor will also affect the refresh process.
For more details, you can refer this official article.
Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-chenwuz-msft ,
I understand, but our network does not show any instability during the update process.
The only difference really is that on demand process it is faster.
Do you think any configuration changes in the gateway file would make any difference?
I just did a new manual update and the time difference is very big.
Thank you for your help!
Hi @PedroGomesANCD ,
For scheduled refresh, it has a certain delay. You can refer to specific official documents:
Data refresh in Power BI - Power BI | Microsoft Docs
You can find out the actual time it refreshed, by checking the gateway logs.
As far as I know there is no special setting for scheduled refreshes.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@PedroGomesANCD , You have done it just after the last load has finished, so I doubt not much data for a refresh, depending on the setting.
can you check a manual one before the scheduled one and check
Hi!
I don't use incremental update.
The entire dataset is completely updated ever.
If I run on-demand update now, the time to complete is the same (2 minutes)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |