NEW FEATURE! Import Dynamic Arrays into Power Query + 8 Warnings

/in /by

Just 2 days ago it became possible to import Dynamic Arrays into Power Query. 🙏🏼🎉
This is really cool. HOWEVER! There are 8 warnings that I take you through.

First. There is no longer “table-slash-range.” The icon has been changed to “From Sheet.” BOOOO! 🤪 Table/range seems more accurate.

Check out the video for the other 7 warnings. They’re too hard to explain. You just have to see them.

#DynamicArrays
#ImportFromDynamicArrays
#Power Query

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2