How to prevent power query editor from reloading data everytime steps are modified

Hi  jasonyeung87 ,

When you open Query Editor in power bi desktop, select the table that you do not want to refresh, right click it and disable Include in report refresh (it is active by default), close and apply Query Editor and the table will not refresh when the report is refreshed.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Apply-query-changes-without-refresh-data/m-p/588471

https://community.powerbi.com/t5/Power-Query/Avoiding-data-reload-when-applying-Power-Query-changes/td-p/775446

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.