Forum Discussion

danielschmidt's avatar
danielschmidt
Copper Contributor
Feb 17, 2026

Organizational Account authentication problem

I have encountered a new authentication problem using an organizational account with Get Data > From Web. The data source is Dynamics 365 CE on-premises (https://ce.xxx.com/api.data/v9.1), authentica...
admin
power bi
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 18, 2026

This is a known, frustrating issue that typically arises from a token caching mismatch or a broken authentication state within the Excel/Office identity broker. Since it works in Power BI Desktop but fails in Excel (and specifically the "Sign in as different user" button behaves erratically), the issue is almost certainly local to the Excel client's handling of ADFS/WS-Fed modern authentication.

Clear the Office Credential Cache (Most Likely Fix)

The symptom where the "Sign in as different user" button opens and closes immediately suggests Excel has a corrupted or stale cached token for ce.xxx.com. It tries to use the token, fails, but the UI logic to request a new one is broken.

  1. Close Excel completely.
  2. Open Control Panel > User Accounts > Credential Manager (or search "Manage Windows Credentials").
  3. Go to the Windows Credentials tab.
  4. Look for any credentials related to ce.xxx.com, Dynamics365, or MicrosoftOffice16_Data:adalsso.
  5. Remove all of them.
  6. Advanced Step: If the above doesn't work, you may need to clear the ADAL cache files. Close Excel, then delete the contents of:
    %localappdata%\Microsoft\Identity\ADAL
    (Note: This will force a re-login for all Office apps).
  7. Restart Excel and try the connection again.

 

Force WebView2 Repair

Repair WebView2 runtime:

  • Go to Apps & Features
  • Find Microsoft Edge WebView2 Runtime
  • Repair

Or reinstall it.

If your organization recently updated security policies, Excel might have fallen back to legacy auth. You can force it to use the modern ADAL/OWA stack via the registry.

  1. Open regedit.
  2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity.
  3. Create a DWORD (32-bit) Value named EnableADAL.
  4. Set the value to 1 (or 2 for "Force ADAL").
  5. Also, check HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity\DisableADALatopWAMOverride and ensure it is set to 1 (to prevent the Web Account Manager from interfering with ADFS).
  6. Restart Excel.

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.