Power query - Excel 365 to Salesforce sandbox

Anonymous
2020-05-05T10:12:10+00:00

When trying to connect to a Salesforce sandbox (Data > external sources > Salesforce object) i'm redirected to dummy page after entering my login credentials in the popup (.../promos.html):

connecting to production works fine.

connecting trough powerBI desktop works fine.

many thanks,

cédric

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2020-07-27T16:33:46+00:00

MS support is working on a structural fix. in the meantime a non official workarround that worked for me (to use at your own risk) is:

• For 32-bit versions of Excel running under 32-bit versions of Windows and 64-bit versions of Excel running under 64-bit versions of Windows, the key is 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION

• For 32-bit versions of Excel running under 64-bit versions of Windows, the key is 

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION

Either way, please create a new DWORD 32bit value under that key with a name of excel.exe and a value of 0x2af8 (or decimal 11000).

best of luck,

Cédric

Was this answer helpful?

10+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2020-07-28T02:12:04+00:00

Salesforce is working on this issue with Microsoft.

This could not solve by Saesforce

itself, so need Microsoft to do their effort on their side.

You may subscribe within below page through click ‘this issue affect me’, then you will be notified when this has solution.

https://trailblazer.salesforce.com/issues_view?id=a1p4V000001YqEeQAK

Was this answer helpful?

4 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2020-07-22T13:43:19+00:00

Hi All,

Sorry about the inconvenience caused by this issue. We can also reproduce this issue on our side.

As there are multiple users reporting this issue, we will set this thread as a primary thread, and if there are any updates on this issue, we will update the summary in this thread.

Issue symptom:

When you go to Excel > Data > Get Data > From Online Services > From SalesForce Objects/Resources.

After sign in with your salesforce account, it won't give you the table you want but redirect you to the promos.html page.

 

Issue environment:

Excel

Microsoft 365 Apps for Enterprise version 2007 (Build 13029.20236) Current Preview Channel

Microsoft 365 Apps for Enterprise version 1908(Build 11929.20838) Semi-Annual Enterprise Channel

Current Status:

We are looking into this issue, and will involve more related resources for further investigation.

Please wait patiently, if there are any updates, we will post back here. Please subscribe this thread to get informed.

Appreciate for your understanding.

Regards,

Alex Chen

Was this answer helpful?

2 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2020-07-30T19:41:42+00:00

Our org found a workaround to this issue by choosing 'Use Custom Domain' at the login prompt - do not attempt to enter your password first.   I got a token error initially, but once the token was reset this process worked - we can refresh our files again.

Note: We use an SSO for Salesforce which our Custom Domain directed to, not sure that makes a difference.

Was this answer helpful?

0 comments

86 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-28T19:12:54+00:00

    We've also found that you will need to search under the same path for the HKEY_CURRENT_USER portion of the registry as well, in addition to HKLM.  

    If you are an IT person connecting to a remote registry for a user, just search under the HKEY_USERS hive for FEATURE_BROWSER_EMULATION.  There may be conflicting settings there, and HKEY_CURRENT_USER seems to take precedence.

    Entries for excel.exe (d-word 11000 decimal) and PBIDesktop.exe (dword 11000 decimal) will need to be entered in all locations to resolve both the excel and power bi login problem.

    We may be just band-aiding the problem for now until Dec 2020 when Salesforce ends support for IE 11 altogether.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments