When a Query is called Query?

[lezawang]

Hi
If I have a table and then if I go to Data-->From Table and select that table, then Power Query would be open. If I "Close and Load" then the table will be loaded to the Excel sheet. That is called Query, right?

Now, if I do the same thing again but instead of Close and Load, I select "Close and Load To" then select "Create a connection only" then that would be called a Connection only.

So does that mean, this action

Data--> From Table/Range <<-- is not Query yet?

It will be called Query only if I "Close and Load" because if I "Close and Load To" then select "Create connection" Then that would be called "Connection"

Before, I was thinking the action to select a table and bring it to Power Query Editor is called Query. Can you please help to clarify this. Thank you very much.

 

[Excellent Excel]

Not sure when it 's called query or not. The difference is that if you select "Close and Load", your table automatically goes to Power Query, if you select "Create a connection only", you can indeed just create a connection to a table instead of having a (useless?) copy of that table in Excel again. Just don't forget to check "Add this data to the data model", or you won't have the table in Power Pivot - unless you don't want it there, but with my current knowledge, I don't see the point of putting it in Power Query if it doesn't go to Power Pivot...

Maybe someone else can explain further...