High severitycredentials
Power BI Refresh Error:
SalesforceOauth2ClientCredentialFailure
What does this error mean?
ADF failed to authenticate to Salesforce using OAuth 2.0 Client Credentials. The client ID, client secret, or token endpoint configuration in the Salesforce linked service is incorrect or the connected app permissions are insufficient.
Common causes
- 1The Salesforce Connected App client ID or client secret stored in the linked service is incorrect or expired
- 2The Salesforce org's OAuth settings have been changed after the linked service was created
- 3The Salesforce Connected App does not have the required API scopes (api, refresh_token) enabled
- 4IP allowlist restrictions on the Salesforce org are blocking the ADF integration runtime IP
How to fix it
- 1In the ADF linked service for Salesforce, verify the client ID and client secret match the values in the Salesforce Connected App.
- 2Log into Salesforce Setup > App Manager and confirm the Connected App is enabled and has "api" scope.
- 3Regenerate the client secret in Salesforce if it may have expired and update the linked service.
- 4Check the Salesforce org's login IP restrictions and add the ADF integration runtime IP if needed.
- 5Use the "Test connection" button on the linked service to verify credentials.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-salesforce