Forum Discussion
How to get dynamic array into Power Query?
tanacal 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.
Not sure though what that has to do with 'merging two queries'.
tanacal As I said, yes. You select a cell anywhere inside the array and select From Data/Range.
- 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.
tanacal No! The "From Sheet" button only existed a very short time on the Insider/Beta channel.
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 =Sheet1!$A$1# and call it anyway you want. The click anywhere within the array and hit the From Table/Range button.