Hi, @GD-L
According to the official documentation, the on-premises data gateway does not support service principal authentication. This limitation can be the root cause of the problem you are experiencing. Service principal authentication methods are designed for cloud-based data sources and may not work with on-premises data gateways as expected. You can check the focumentation:
Service principal support in Data Factory - Microsoft Fabric | Microsoft Learn
Even if you mention that all the connection IDs/keys are correct, it's worth double-checking the credentials. Ensure that the tenant ID, service principal ID, and service principal key are entered accurately without any typographical errors. For more detailed steps on setting up service principal authentication, you can refer to the SharePoint Online List Connector documentation:
Configure SharePoint Online List in a copy activity - Microsoft Fabric | Microsoft Learn
Ensure that the permissions granted to the service principal are correctly configured and that admin consent has been granted to the service principal. The permissions you list should usually be sufficient to perform a read operation, but it's critical to confirm that they're active and not waiting for admin consent.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
