We noticed it first on April 20, 2021… the Get & Transform Data group’s “From Table/Range” changed to “From Sheet”. Hover over the tooltip, and you will discover that they now support arrays!

This is great news. Power Query is the best thing to happen to Excel. Dynamic Arrays are another great improvement in Excel. The situation that they could not work together before this was unfortunate. Kudos to the Power Query team for providing the functionality!

Not that this is currently released to the “Beta” channel (Formerly known as Insiders Fast). It will take some time to roll out to all Microsoft 365 customers.