Stop refreshing/loading data on each step

[sparvez]

Hello altruists,

Whenever I go back and foth Power Query Steps, it load/refresh data on every click.

How do I stop this. I want each step to show last data, the should not load/refresh data until I click 'load/refresh' icon.

Can anyone help pls?

thanks

[AlexisOlson · Accepted solution]

You could try this setting under File > Options and settings > Options