For a long time we had to provide legacy ACS permissions for Microsoft Azure Data Factory to connect to SharePoint. That’s not the case anymore. Finally Microsoft updated authentication page so ADF V2 supports authentication with Client Id and Certificate, which means that application registration used to connect to SharePoint can have only modern Sites.Selected API permissions.
Step-by-Step guide ADF connect to SharePoint with Certificate
- Obtain a certificate
- Get a registered app in Azure
- app should have both – Microsoft Graph API and SharePoint API permissions configured and consented
- under Secrets and Certificates – the certificate uploaded
- Provide access for the app id (client id) to SharePoint site
- under ADF – configure linked service –