Forum Discussion
How to get dynamic array into Power Query?
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.
Thanks for your reply. I have tried it this morning. However, something strange happened.
I did exactly the same thing as you described in the message and I kept getting an error message. So I was going to try it again so I can share the error message with you.
However, I was not able to get it through this time. I named the array as "Array", saved and closed the excel spreadsheet. Then re-opened the excel and went to power query editor, inserted a new blank query, put in the formula = Excel.CurrentWorkBook() as before, but this time I could not see the name range "Array" as before. Don't know why? pretty strange. I knew I saw it yesterday, and I was able to go thru this step yesterday.