Forum Discussion
How to get dynamic array into Power Query?
Hi, 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. ...
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'.
- May I what button were you referring to? From Table/Range? Thanks,
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.
