Forum Discussion
Suppress refresh in Power Query when not necessary
Hi ns29 ,
It seems that you want to refresh partial data, right? I think you might could try the incremental refresh, you could service-premium-incremental-refresh for details. But you need to pay attention, incremental refresh also has some limits, you could refer to above link.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dax, I'm not looking to refresh any data in a single session of analysis once the data has been pulled into the file. Incremental refresh would not work in my case unfortunately as it asks for parameters on the data set itself where I have none set.
I know I'm doing something wrong, hard to believe the engine isn't smart enough to know when to not fetch data. Hopefully someone else can chime in here.
Thanks!