Service principal key

Question

Hello.

I have a question. I got this error below. How can I solve this error?

"Microsoft 365 only supports copying to sink dataset with linked service using Service Principal authentication. Please correct the authentication type in linked service."

Now I'm using data factory and trying to connect Office 365 to data storage gen2.

To do so, I created a new registration, and I found information of the application ID.

Does this application ID work as a service principal ID? and what is the service principal key?

is it the value of client secrets or secret ID?

I was using application ID as the service principal ID

and using the value of client secrets as the service principal key and got this error above.

Kind regards

Satoko Murata

Answer 1

Hello @Satoko Murata ,

Welcome to the MS Q&A platform.

From the error message, it seems you are not using the service principal authentication in the sink dataset, causing this error.

Please follow the below document explains how to load data from O365 to Azure blob storage using ADF.

https://learn.microsoft.com/en-us/azure/data-factory/load-office-365-data

and for your question, your understanding is correct. The new app registration application(client) ID will be the service principal ID.

And the secret value (created from the certificates & secrets) is the service principal key.

Please see the below screenshots for your reference.

I created a new app registration called: ps-bhargavadatabricsapp and using the application ID and the secreate value, I was able to create O365 linked service connection.

Connector documentation:
Copy and transform data from Microsoft 365 (Office 365) into Azure using Azure Data Factory or Synapse Analytics

I hope this helps. Please let me know if you have any further questions.

If this answers your question, please consider accepting the answer by hitting the Accept answer button, as it helps the community.