Connection vs Query in Excel data model

Question

What is the difference between a 'connection' and a 'query' as Excel defines it in their data model? For example, if I load a csv file from local, it stores that as a query (it shows a 'select *' as the query against the file). What then would be considered a connection and what's the difference between the two? The only thing I can think of is that a connection would not return data without specifying the table/query to use-- for example, a database connection where it has multiple tables, and possibly, connecting to another Excel file if it had more than one tab.

Reference: https://support.microsoft.com/en-us/office/create-edit-and-manage-connections-to-external-data-89d44137-f18d-49cf-953d-d22a2eea2d46

Answer 1

There are various ways to construct and load Power queries into your worksheet using Power Query. In the Query Options window, you can also select default query load parameters.

Select a cell of data in a spreadsheet to see if it was shaped by Power Query. If the Query context ribbon tab shows, the data was loaded from Power Query.

Select Data > Queries & Connections in Excel, and then the Queries tab. Locate the query in the list of queries, right-click it, and then select Load To. A dialogue window called Import Data opens. Select OK after deciding how you wish to import the data.