Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Reports & DashboardsTimothy Skalaban's Question
Timothy Skalaban asked in #Reports & Dashboards
Dec 15, 2016, 4:42 PM

The service returned an invalid token. Please contact your IT administrator if this issue persists

When refreshing an existing connection, to a Salesforce Report through Microsoft Excel Power Query, I am told the credentials are invalid. I verified I can login to Salesforce.com. After I received this message and tested I can login to Salesforce.com, I tried to resign into my account in Microsoft Excel Power Query. I then receive the following message:

 

“The service returned an invalid token. Please contact your IT administrator if this issue persists”.

 

I have successfully used this Power Query connection for the last year with no problems.  This is the first time I have come across this. 

 

 

 

 
13 answers
Loading
  1. Andrew Woloszyk
    Dec 19, 2016, 10:15 PM
    Hey, guys. Drea is right. Salesforce updated their security protocol to TLS 1.1. For some reason, Microsoft still has .net 4.0 applications using TLS 1.0 by default. You can fix this by enabling TLS 1.2 for all .net 4.0 applications in the Windows Registry. I found the following fix on Microsoft TechNet:

     

    To enable TLS 1.2, it is possible to set the SchUseStrongCrypto DWORD value in the following two registry keys to 1, creating them if they don't exist: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319" and "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319". Those registry keys, however, will enable TLS 1.2 in all installed .NET 4.0 applications on that system.

     

    Source: https://social.technet.microsoft.com/Forums/en-US/92811d44-1165-4da2-96e7-20dc99bdf718/can-power-query-be-updated-to-use-tls-version-12?forum=powerquery
Write an answer...
0/9000