May 10 2018
02:23 AM
- last edited on
Jul 12 2019
11:08 AM
by
TechCommunityAP
May 10 2018
02:23 AM
- last edited on
Jul 12 2019
11:08 AM
by
TechCommunityAP
Hi
I usually access Salesforce through excel, but since this morning the connector seems to be missing from the "Get Data" drop-down. Any ideas?
If I go to "Data source settings" I can see Salesforce listed, will all Permissions working OK.
Jan 19 2019 01:51 AM
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.
Jan 19 2019 04:39 AM
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.
Jan 19 2019 05:51 AM
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..., it says
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.
Jan 21 2019 09:28 AM
Jan 21 2019 10:24 AM - edited Jan 21 2019 10:25 AM
Hi,
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.
Jan 29 2019 04:44 PM
You can still use the connectors that are not available with non pro versions; as power query needs them for compatibility reasons (the only thing missing are the buttons to call them).
Just open a blank query and write the data functions directly.
For example: = Salesforce.Data()
https://docs.microsoft.com/es-mx/powerquery-m/salesforce-data