Troubleshoot the SharePoint Online list connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Data Factory in Microsoft Fabric is the next generation of Azure Data Factory, with a simpler architecture, built-in AI, and new features. If you're new to data integration, start with Fabric Data Factory. Existing ADF workloads can upgrade to Fabric to access new capabilities across data science, real-time analytics, and reporting.

• Start a Fabric free trial.
• Upgrade from Azure Data Factory to Data Factory in Microsoft Fabric

This article provides suggestions to troubleshoot common problems with the SharePoint Online list connector in Azure Data Factory and Azure Synapse.

Error code: SharePointOnlineAuthFailed

• Message: The access token generated failed, status code: %code;, error message: %message;.

• Cause: The service principal ID and key might not be set correctly.

• Recommendation: Check your registered application (service principal ID) and key to see whether they're set correctly.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Data Factory blog
• Data Factory feature requests
• Azure videos
• Microsoft Q&A page
• Stack Overflow forum for Data Factory
• X information about Data Factory