How to Setup Service Principal for Microsoft Outlook 365 Connector?

[AdarshChekodu]

Hello All,

I remeber initally M365 Outlook Connector didnt support Service Pricipal authenticaion. But now when I open it I can see the Service Principal option. I couldnt find any documentaion on how to set up the same? 

Could anyone shed some light on this please. 

Thanks,

Adarsh

[v-sgandrathi]

Hi @AdarshChekodu,

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know Glad to help. 

Thank you.

[v-sgandrathi]

Hi @AdarshChekodu,

Thankn you @tayloramy and @apturlov for your response to the query.

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

Thank you.

[tayloramy]

Hi @AdarshChekodu, 

As far as I know, the Office 365 Email connection doesn't support service principals. The option is there in the UI, but it doesn't work. 

I've tried with various API permissions and have never been successful with it.  

[apturlov · Accepted solution]

Hi @AdarshChekodu , thanks for your timely question. First, it seems there is only limited documentation for the Office 365 Email connection in Fabric. Specifically, it's required for a data pipeline Office 365 Outlook activity. You can read it about that here Office 365 Outlook activity - Microsoft Fabric | Microsoft Learn, but, spoiler alert, it does not explain specifically about Service Principal configuration.

If you select a Service Principla authentication when creating a connection you see this:

As in any other Fabric connection that can use Service Principal authentication you need to have a Service Principal created in Entra ID. This generic guide explains how to set up a service principal Service principal support in Data Factory - Microsoft Fabric | Microsoft Learn. This article does not specifically mention the Office 365 Email support, as I imagine it's just a recently enabled feature, so docs are behind. But, there is not much special about Office 365 apart from the permissions that are needed for the service principal that are assigned in Entra by an Entra Admin.

You may need to do some additional research about the permissions but I recon the standard API permissions you can find for Office 365 should be enough as shown on a screenshot:

Hope this information is enough to let you progress with the setup. If you don't mind, please share ther results of your experiment.

If you find this answer helpful, consider giving it kudos and mar as a solution.