Referring to PowerQuery or Duplicating it: What's the difference?

[rizzo93]

What is the difference between referring to a powerquery table and duplicating it?

Does referring to it make it refresh automatically when the original is updated, too?

 

[C Moore]

Referring will take all the steps done in the original query and start from there. Duplicating brings all the steps over. Referring does not take the result of the other query and then the new steps added but runs through it all on refresh.

 

[rizzo93]

Thank you C Moore. Much appreciated.