How to get dynamic array into Power Query?

Question

Hi,&nbsp;&nbsp;I am in Monthly Enterprise Channel of version 2306. I am wondering if there is alternative work-around to make dynamic array information getting into Power Query so I can merge two queries.&nbsp;&nbsp;Thanks, appreciated!

riny_van_eekelen · Answer

tanacal&nbsp;You can connect to a dynamic array with PQ just like you connect to a table or a range. You use the same button on the user interface.&nbsp;Not sure though what that has to do with 'merging two queries'.

tanacal · Answer

May I what button were you referring to? From Table/Range? Thanks,

riny_van_eekelen · Answer

tanacal&nbsp;As I said, yes. You select a cell anywhere inside the array and select From Data/Range.

tanacal · Answer

It works but later come back with a error message. I think the people with insider channel has a button like from sheet or from selection will work.

riny_van_eekelen · Answer

tanacal&nbsp;No! The "From Sheet" button only existed a very short time on the Insider/Beta channel.&nbsp;&nbsp;Anyway, all that this 'feature' does is to automatically create a named range called "Array_1", "Array_2" etc. and then create the connection to that newly created named range. You could do that yourself. Let's say a dynamic array start in A1 on Sheet1, create a new named range and point it to&nbsp;=Sheet1!$A$1# and call it anyway you want. The click anywhere within the array and hit the From Table/Range button.

Forum Discussion

How to get dynamic array into Power Query?

7 Replies

Resources