Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All, I am using Microsoft Office Standard 2016. I want to use PowerQuery option for fetching data from Salesforce to excel but I am unable to see 'Salesforce' option under 'Get & Transform'. Let me know what is required to configure at my end.
Regards,
Prateek Arya
Hi @prateekarya1989,
Based on my research, the default setting for Office 2016 is to use TLS 1.0 which has at this point been disabled in most Salesforce Orgs. If you still cannot see this option, please refer to below links to troubleshoot:
64 bit Excel Power Query, Office 2016
The service returned an invalid token. Please contact your IT administrator if this issue persists
Besides, your current issue is more related to Salesforce connector and Excel tool, I would suggest you post your question in Salesforce forum and Office forum so that you can get more professional advice.
Best regards,
Yuliana Gu
HI, Can you please share the direct link of the extension as I am unable to find it.
Also, I have one doubt.
I am using Office Standard 2016. Is that available in same or I need to upgrade to Professional 2016 office.
Regards,
Prateek Arya
Hi @prateekarya1989,
As this the forum supports Power BI, please post your questions in Saleforce or Excel so that you can get more help. Thanks for your understanding.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
https://powerbi.microsoft.com/en-us/blog/announcing-power-query-support-for-salesforce-com/
https://success.salesforce.com/answers?id=90630000000DNcmAAG
https://powerbi.microsoft.com/en-us/blog/4-new-updates-in-power-query/
Hope that helps!