Forum Discussion
Data limit on auto refresh
Hi,
I have a few tables that have a lot of rows and powerbi auto refresh fetches all the rows at the same during refresh. Is there a way I can limit the number of rows in a single pull. eg Pull the data in 10k chunks instead of 100k at a single time. My DB gets hung up when such a big database if pulled in a single go.
Some sort of limit offset option available?
Hi Anonymous,
Based on my research, if you have the Premium license, you could use the Incremental refresh function to set the partial refresh.
Reference:https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Regards,
Daniel He
2 Replies
Hi Anonymous,
Based on my research, if you have the Premium license, you could use the Incremental refresh function to set the partial refresh.
Reference:https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Regards,
Daniel He
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He