Forum Discussion
christophelel
Jul 21, 2020Copper Contributor
Excel Power Query fails to connect to salesforce
since last week, in Excel, I cannot import data from Salesforce Report. It fails to login to Salesforce. no error message. Login screen is presented again. Office365 Enterprise, Excel 2007, win 10 ...
iw-prb
Jul 21, 2020Copper Contributor
christophelel same problem for us, though the connection does work in Power BI for some reason. On the SF forums, someone said they had the same issue with Excel 2006 but a colleague who runs Excel 2005 did not have the issue. May or may not be a reason but sharing here in case relevant.
Tried to look at the release notes for Excel 2005>2006 but did not find any obvious reasons.
- Anthony CouzensJul 21, 2020Copper Contributor
iw-prb @christophelel we have the same issue here. Every time I enter the login details to the oauth screen it clears it down and I am asked to reenter username and password in an infinite loop. We have lots of reporting from this source so it's a major issue for us operationally.