Use query results in another excel sheet.

[Mic1979]

Dear all,

I do hope you can help me with this.

I have a query with more than 300.000 rows (I know they are too much, but this is..)

My first willing would have been to export them in an excel sheet and use the table in another workbook for more analysis.

I am wondering if it is possible to use the query result in another excel workbook without loading them in an excel table.

Thanks.

[Anonymous · Accepted solution]

Hi @Mic1979 ,
According to your description, you can connect directly to the data source but not load the table, and after you fetch the data, you can choose to create a connection only to fetch the data without loading it

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Omid_Motamedise]

A simple way is create two different queires in two different file and refresh them separately. 
there is a way to export part of your query into another fuile but I do not recomend it due to some of its drawback.

[lbendlin]

use the query result in another excel workbook without loading them in an excel table

use them how?  What are you trying to achieve?

[Mic1979]

I need the table in power query editor in the workbook B...

I need to make on that operations, andh only at the end I will produce a table in excel

[lbendlin]

So - you want to re-run the query in workbook B then?