Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
Power Query Public: Available for all other Office 2013 Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce.
Exactly the same for Office365 - for Pro versions is PQ Premium, all the rest, includes Home, are on PQ Public.
I have both E3 and Home subscriptions, never seen on the latest Premium connectors.
without being able to bring evidences, I have the feeling my 2016 Home and Business Version lost features from 2016 to 2019.
I read that those packages contain "full featured applications", but well. I think things like these happen. I don't know why live need to e so complicated and why Microsoft decides to build Variants differentiating on such a deep level of detail. This is not going to make difference to income of MS, but User support so much harder.
Anyway, I am a lucky guy and my company is in the Home-Use Programm. So I got me there a "Professional Plus 2019" Version. The connectors re appeared and the problem is solved.
Bad luck for the ones in future, who might get into the same situation of feature erosion.