How do I create a connection only query in Excel?

Question

Right-click on each query and select Load To., then. Select connection only - this will not load anywhere, but would be used as a query for use by other queries in Power Query. Table - this will load the query into an Excel Table.

What is a connection only query in 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.

How do I create a Power Query connection?

Go to the Data tab > Get & Transform group and click From Table/Range. In the Power Query Editor that opens, click on the Close & Load drop-down arrow (not the button itself!) and select the Close and Load To… option. In the Import Data dialog box, select the Only Create Connection option and click OK.

What is the difference between a query and a connection in Excel?

Edit: Let's put it this way: The connection is just that. It connects your workbook to a data source. Like a highway connecting two cities. A query is the request for actual data that you spell out, calling from your workbook (via the connection) into the data source.

Expert · Answer