Function of Queries and Connections tabs

[INN]

Hi
I have 1 query and 1 connection. When I go to Queries and Connections pane, and click on Queries tab, I will see both of them Table1 and Table2 (please see screenshot#1) but when I click on Connections, I will not see anything (please see screenshot#2). What I thought, when I click Queries tab I should see only the queries (in this case Table2) and when I click on Connections, I should see only the connections (in this case Table1) but that is not the case. Why is that. Thank you very much.

Screenshot#1

Screenshoot#2

 

[alansidman]

The connections are for other than Power Query. ie. Links to MS Access or other third party. You have two queries. One is displayed in Excel and the other is stored and not visible until you open Pq (the one listed as a connection.)

 

[smozgur]

I honestly don't understand why they are using the "Connections" label for that tab. Because, as far as I can see, it only shows the data model information, and only shows the data model that you created. If you create a query based on a table in a worksheet and choose add it to the data model during the "Load" then it will be also displayed in the "Connections" tab. That's for pivot table usage. so you can make a relation between the tables that you added into the data model by specifying the relation fields between tables. The reason of external data shows in that tab, I guess, those data sources are added to the data model since they are based on relational databases.

The queries tab, on the other side, contains queries that are used in a worksheet OR connection-only queries. Still, I really think that they should change the Connections label to something else. It is confusing.