Excel Power Query Connection Only Explained

How-to basics · Updated November 21, 2026

In Excel Power Query, Connection Only saves a query in the workbook without loading its results into a worksheet table. The query can still be refreshed and used by other queries; on Windows, choose Only Create Connection in the Load To dialog to use this setting.

What Connection Only means

A Power Query query records instructions for retrieving and transforming data, such as connecting to a file, removing columns, filtering rows, or combining tables. Loading a query determines where its resulting data appears. A worksheet table is one possible destination, but it is not required: a query can remain in the workbook as a connection without displaying its result on a sheet.

This distinction is useful because a query can do important work behind the scenes. For example, one query might import several years of sales records and standardize their column names. A second query could use that prepared result to calculate a report for the current year. The first query can be connection-only, while the report query loads to a worksheet. The source query still matters even though its intermediate rows are not shown.

Connection Only does not mean that Excel forgets the query, that the query is disabled, or that it has no source. It also does not mean the query result is automatically added to the Data Model. Those are separate choices in the Load To dialog.

How to set a query to Connection Only

In Excel for Microsoft 365 on Windows, use these steps for a new query:

  1. Go to Data > Get Data and choose a source, or open an existing query in the Power Query Editor.
  2. Make any required transformations in the editor.
  3. On the editor’s Home tab, select the arrow next to Close & Load, then choose Close & Load To….
  4. In the Import Data dialog, select Only Create Connection.
  5. If you also want the result in the Data Model, select Add this data to the Data Model as well, then select OK.

To change an existing query, open Data > Queries & Connections. In the Queries pane, right-click the query and choose Load To…. Select Only Create Connection and confirm. If the query was previously loaded to a worksheet, changing its load destination can remove or replace that output, so check the sheet before making the change.

For a query that should appear as a normal table, use the same dialog but choose Table. The exact controls may vary with Excel build and the type of query, but the central choice is whether to load results to a sheet, the Data Model, or neither destination.

Where to find connection-only queries

Connection-only queries appear in the Queries & Connections pane, usually with an icon or description indicating that they are connection-only. Open the pane from Data > Queries & Connections. From there, you can inspect query names, open the editor, change load settings, and use the context menu to refresh or manage a query.

They do not have a result table on a worksheet, so you cannot click a cell to inspect their full output. To preview the transformation steps, open the query in the Power Query Editor. To examine the final rows as worksheet data, temporarily change its load destination to a table, or create a separate query that references it and load that new query. Loading a large result just for inspection can take time and consume workbook space.

A connection-only query is not the same thing as a traditional database connection listed under workbook connections. Excel’s data features can expose connection information in more than one interface. For Power Query work, the Queries pane is the practical place to manage the query and its load destination.

Why use Connection Only

The most common reason is to keep intermediate data out of sight while preserving reusable transformation steps. A workbook with several stages—raw imports, cleaned tables, and final reports—can be easier to navigate if only the final outputs occupy worksheets. It can also avoid creating duplicate tables when a result is needed by another query but not directly by a reader.

  • Staging: Import a folder of monthly files, standardize the columns, and keep the combined staging query connection-only.
  • Reusable cleanup: Clean customer names or dates once, then reference the cleaned query in several report queries.
  • Data Model reporting: Add a query to the Data Model without placing its rows in a worksheet, then use it in a PivotTable or other model-based analysis.
  • Cleaner workbook layout: Avoid showing raw or intermediate records on tabs intended for summaries and charts.

Connection Only does not necessarily make refresh faster. Excel may still need to retrieve and transform the source data when refreshing a dependent query or updating the model. Its clearest benefits are controlling where results are loaded and organizing a multi-query workflow, rather than eliminating the work of processing data.

Connection Only versus loading to a worksheet or Data Model

Choose a destination based on how the result will be used. Loading to a worksheet creates a table that users can read, filter, and reference with ordinary Excel features. It is a good choice for a modest-sized result that people need to inspect directly. Worksheet row limits and workbook size matter for very large datasets.

Choosing Only Create Connection keeps the query available without placing its output on a sheet. A downstream query can reference it, or it can be used as an input to a model load. If no other query, model, or workbook process uses the result, a connection-only query may have little visible purpose, though it can still be retained as a prepared step for future work.

Adding a query to the Data Model stores its data for model-based analysis, such as relationships between tables and PivotTables based on the model. The Data Model is not a worksheet table. In the Load To dialog, Excel can allow Only Create Connection and Add this data to the Data Model together: the first controls worksheet output, and the second controls model loading. A model load can use substantial memory, so it is not automatically the best option for every query.

How query dependencies and refresh work

Power Query supports queries that build on other queries. In the editor, a new query can reference an existing query, allowing the existing transformations to serve as a reusable starting point. This is different from independently importing the same source again: dependent queries can share the logic of a staging query, although Excel may still perform source and transformation work when refreshing.

For example, imagine a folder query that combines monthly sales files and a staging query that fixes data types and removes blank rows. A connection-only staging query can feed separate queries for regional summaries and product summaries. Load the summaries to worksheets or the Data Model as appropriate, while leaving the common preparation step off the sheets.

Use Data > Refresh All to refresh workbook data connections and queries, or use the query’s context menu in the Queries & Connections pane to refresh an individual query. Refresh behavior can depend on the source, query dependencies, credentials, and connection settings. If a report looks out of date, check whether the relevant source and dependent output were refreshed rather than assuming that a query’s connection-only status prevents refresh.

Refresh settings can be managed through connection or query properties when those options are available for the particular query. Options such as refreshing when the workbook opens depend on the connection and Excel interface. For shared workbooks, consider whether automatic refresh is desirable: it can make reports current, but it can also trigger prompts, take time, or fail when a source is unavailable.

Common problems and practical checks

  • The query is missing from a worksheet. That is expected if its destination is Only Create Connection. Find it in Data > Queries & Connections and use Load To if you need a visible table.
  • A dependent query cannot find the expected data. Confirm that the source query still exists and that the dependent query references the intended query. Connection-only status alone should not remove a query’s availability to other queries.
  • Refresh asks for access or credentials. Excel may need valid permissions or authentication for the original source. The load destination does not bypass source access requirements. Resolve the sign-in or permission issue using the source and workbook’s normal security process.
  • Refresh fails after moving the workbook. A query may point to a local file path, network location, database, or online source that is unavailable from the new location. Check the source path and access, then edit the query’s source step if it needs updating.
  • The workbook is still large or slow. Connection-only prevents a worksheet copy of the result, but it does not guarantee that the workbook stores no data or that refresh is lightweight. A Data Model load, query dependencies, cached information, and source processing can all affect size or performance.

Before distributing a workbook, review its query sources and transformations. A connection-only setting is a loading choice, not a privacy control: it does not conceal sensitive source details from someone who can inspect the workbook, nor does it ensure that a recipient lacks access to the source. Share only workbooks and data that recipients are authorized to receive.

Excel for Mac and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. Power Query features, supported sources, and the available editing and load controls can differ by Excel version and platform. Excel for Mac has Power Query capabilities, but the Windows ribbon paths and dialog sequence should not be assumed to match every Mac release. Look for the query’s load options in the Mac edition’s Power Query and data interfaces, and consult the current Microsoft support information for the installed version if a setting is absent.

Excel for the web also has a different feature set from the Windows desktop application. Depending on the workbook and source, web-based refresh or query editing may be limited. If a workbook’s query destination or source needs to be changed and the appropriate controls are unavailable online, open it in the desktop application that supports those operations. Avoid promising that every connection can be refreshed from every platform.

Frequently Asked Questions

Does Connection Only still refresh?
Yes. The query remains in the workbook and can be refreshed, subject to source availability, permissions, and its connection settings. Connection Only controls where the query result is loaded; it does not by itself turn refresh off.

Can I use a connection-only query in another query?
Yes. A query can reference another Power Query query even when the referenced query is not loaded to a worksheet. This is a common way to keep staging and cleanup queries behind the scenes.

Does Connection Only add data to the Data Model?
Not automatically. In the Load To dialog, select Add this data to the Data Model if you want model data as well. Check the selected options rather than treating Connection Only and Data Model loading as the same setting.

How do I make a connection-only query visible?
In Data > Queries & Connections, right-click the query and choose Load To…. Select a worksheet table destination, then confirm. Excel will load the query output to a sheet, which may take time for a large result.

Does Connection Only reduce workbook size?
It can avoid loading a duplicate result table onto a worksheet, but it is not a guarantee of a smaller workbook. A Data Model load and other stored workbook information can still use space, and refresh may still require substantial processing.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.