Excel - Get Data from PDF is Missing

trobinson-q2 

Yes, Home version is quite full functional. The difference with business/enterprise subscriptions is mainly in licensing - in brief you are not allowed to earn money with Home subscription. You shall do business using business subscription. I simplified a bit, nonetheless. You may check availability by SKU here Where is Get & Transform (Power Query) - Excel (microsoft.com)

 Within SKU availability depends on the channel you are subscribed. And more exactly on version within such channel (semi-annual has 3 versions). Thus you have to compare SKU, channel and it's version to compare functionality, plus some time for the deployment. Just "I'm on Office 365" is not enough.

In general deployment of new functionality to all Office365 subscribers, from first Beta users to slowest semi-annual channel users could take couple of years. If you'd like to have new functionality faster you need to change the channel.

And yes, Microsoft could deploy some new functionality and in a while cancel it due to some critical bugs. But that happens quite seldom and not on semi-annual channel. For such changes it's not necessary to update the build, it's enough if you connected to internet. Switching functionality on/off is done by licensing manager assuming such functionality code is within your current build.