Power BI Refresh Error:
SharePointOnlineAuthFailed

What does this error mean?

Authentication to SharePoint Online failed in ADF or Fabric. The service principal credentials are wrong, or ACS authentication is disabled for the tenant.

Common causes

• 1The registered application's service principal ID or client key is incorrect in the linked service
• 2The SharePoint Online tenant was created after November 7, 2018 — ACS (legacy token auth) is disabled by default for these tenants
• 3ACS-based authentication fails with 'Token type is not allowed' because the tenant disables custom app authentication

How to fix it

1. 1Verify the service principal (application) ID and client key in your ADF linked service are correct
2. 2If you see 'Token type is not allowed': enable ACS authentication via SharePoint Online Management Shell
3. 3Download the SharePoint Online Management Shell and sign in with a tenant admin account
4. 4Run: Connect-SPOService -Url https://<tenant name>-admin.sharepoint.com/
5. 5Run: Set-SPOTenant -DisableCustomAppAuthentication $false
6. 6Retry the connection after running the PowerShell command

Other credentials errors