Forum Discussion
Salesforce Connector missing
Hi,
same here, for unknown reasons all Azure connectors including SharePoint connectors are missing. I'm on Build 1901. (Insider)
FYI: the other file connectors are there, but I need SharePoint list connector now.
Are you on Pro?
- baudl0815Jan 19, 2019Copper Contributor
Hi,
no I'm on Home Version, but I want to bet if worked before..But I didn't try to build a connection for very long time. So I could be wrong...
Can you tell where it's written in which Version is which connector available. Some are at least working. (File,XML and so on.) I suspected already something like a "higher-grade" version is required.
- SergeiBaklanJan 19, 2019Diamond Contributor
I'm note sure where is the documentation for 2016, but if to check PQ add-in download page, System requirements https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=55adb75e-0940-4005-876a-3342ef7bfb1b, it says
- Microsoft Office 2013:
- 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.
- SergeiBaklanJan 21, 2019Diamond Contributor
In addition - it's here https://support.office.com/en-us/article/where-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16