Using Connection Only Queries to another file

Power Query

Last Post by Alan Sidman 4 years ago

4 Posts

3 Users

0 Reactions

198 Views

RSS

Faltoo Reg

(@sm)

Posts: 2

New Member

Topic starter

Hi,

Suppose I have 2 excel files "A" and "B". Assuming, file "A" has three connection only queries i.e A-COQ-01, A-COQ-02 and A-COQ-03. On the other hand, file "B" has just one query that is prepared as "Load to Table" its name is B-Query-01, but I want to merge connection only queries made in file "A" with query B-Query-01 that is made in file "B".

Thanks,

Posted : 22/09/2021 6:01 am

Mynda Treacy

(@mynda)

Posts: 4761

Member Admin

Hi Faltoo,

Welcome to our forum! You would need to use Power Query in file A to get the data in the table in file B. From there you can then merge your 4 queries in file A.

Mynda

Posted : 23/09/2021 4:55 am

Faltoo Reg

(@sm)

Posts: 2

New Member

Topic starter

Hi Mynda,

Sorry seems i did not explained clrearly. In fact, my file "A" contains "Connection Only" i.e A-COQ-01, A-COQ-02 and A-COQ-03 not table. So in that case how i can user these connections in file "B" through power query.

Posted : 23/09/2021 5:52 am