Query table not load on sheet

[mr2bart]

Hi,
I am starting to use Power Query.
After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations.
My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel sheet or is there a way to get the data if I do not load my query in a sheet?
(hope I am clear )
Thanks!

 

[sandy666]

table loaded into the sheet is usually end result but you can create pivot table without loading query table to the sheet

btw. don't forget to use appropriate forum for Power Query

 

[mr2bart]

OK thanks ! and sorry for wrong forum

 

[sandy666]

You are welcome