How to Setup Service Principal for Microsoft Outlook 365 Connector?

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.