Switching functionality on/off is done by licensing manager assuming such functionality code is within your current build. The Navigator window displays a list of every proper table in the PDF as well as every page. Browse to the folder that contains the PDF, select the PDF, and click IMPORT. For such changes it's not necessary to update the build, it's enough if you connected to internet. Select Data (tab) -> Get & Transform (group) -> Get Data -> From File -> From PDF. But that happens quite seldom and not on semi-annual channel. If you'd like to have new functionality faster you need to change the channel.Īnd yes, Microsoft could deploy some new functionality and in a while cancel it due to some critical bugs. 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. Thus you have to compare SKU, channel and it's version to compare functionality, plus some time for the deployment. And more exactly on version within such channel (semi-annual has 3 versions). This page teaches you how to convert an Excel file to a PDF file. Within SKU availability depends on the channel you are subscribed.

You may check availability by SKU here Where is Get & Transform (Power Query) - Excel ()

You shall do business using business subscription. The difference with business/enterprise subscriptions is mainly in licensing - in brief you are not allowed to earn money with Home subscription.

Excel import pdf table