Power Query - Create a link

[lezawang]

Hi
When I try to merge (append) 2 tables, I would have to create connections for both tables. Where these connection are located phyiscally? in Excel sheet or in Power Query editor? Thank you very much.

 

[alansidman]

from the website The Complete Guide to Power Query | How To Excel

You can choose to load the query to a table, pivot table, pivot chart or only create a connection for the query. The connection only option will mean there is no data output to the workbook, but you can still use this query in other queries. This is a good option if the query is an intermediate step in a data transformation process.