High severitydata source
Power BI Refresh Error:
DynamicsFailedToConnect
What does this error mean?
ADF or Fabric could not connect to Dynamics 365 or Dataverse. After June 2021, MFA-enabled tenants must use service principal — Office365 auth is deprecated.
Common causes
- 1Office365 authentication with MFA or conditional access is no longer supported after June 8, 2021 — the regional Discovery Service was deprecated
- 2The Dynamics 365 service URL is incorrect, or a proxy/firewall intercepts the request to the Dynamics server
- 3OAuth configuration on the server is incompatible ('Office 365 auth with OAuth failed')
- 4Unexpected server response ('An unsecured or incorrectly secured fault was received')
- 5No organization found — wrong organization name or incorrect CRM regional identifier in the service URL
How to fix it
- 1If you see an error about MFA or conditional access, or the error mentions AADSTS50079: switch from Office365 authentication to Microsoft Entra service principal authentication — this is required after June 8, 2021 for MFA-enabled tenants
- 2To set up service principal authentication, see the ADF Dynamics CRM connector prerequisites documentation
- 3Verify the service URL is correct: for Dynamics 365 online it should be https://<org>.crm.dynamics.com (use the correct regional suffix if applicable)
- 4If using a regional CRM URL (URL has a number after 'crm'), verify the correct regional identifier
- 5For other connection errors: use XrmToolBox to test the connection — if XrmToolBox succeeds but ADF fails, the issue is in the ADF configuration
- 6If error message contains '401 Unauthorized' with an Entra ID error, follow the guidance in the error to fix the service principal configuration