topic Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull in Data Warehouse

How to connect Multi Tenant connection in different domain fabric to synapse data pull

NewUser2025 — Tue, 09 Sep 2025 15:46:14 GMT

I need to connect fabric data warehouse from one domain to different domain with service principle using Azure synapse, I need to copy data from fabric data warehouse to sql database, I need proper steps to give what are the required permissions for service principle and I need required permissions in fabric workspace.
We already created one service principle in Domain-1 Azure (XYZ.123@xyz.com) and we are trying to connect in fabric workspace with Domain-2 Fabric (abc.123@abc.com) using service principle, we are trying to give fabric workspace access to azure service principle (Domain1) but We are unable to see or connect azure service principle

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

Vinodh247 — Tue, 09 Sep 2025 16:18:02 GMT

In your case the problem is that the service principal was created in Domain-1 AAD, while the Microsoft Fabric environment belongs to Domain-2 AAD. Fabric can only see service principals that exist in its own tenant, so the Domain-1 service principal must first be registered as an Enterprise Application in Domain-2. Once you do that, Fabric in Domain-2 will be able to recognise and grant permissions to it.

The sequence is as follows:

in Domain-2 AAD, create an Enterprise Application using the client ID of the Domain-1 service principal, then in the Fabric Admin portal make sure that service principal access is enabled, and finally add the service principal as a member of the Fabric workspace with an appropriate role such as Contributor or Viewer. Inside the Fabric data warehouse, create a SQL user for the service principal from external provider and assign it to db\datareader or db\_datawriter roles depending on whether you need read or write.

After these steps, in Synapse you can configure a linked service to the Fabric SQL endpoint using the same service principal credentials and copy data into SQL Database. The key missing piece in your setup is that the Domain-1 service principal must be explicitly brought into Domain-2 as an Enterprise Application before it can be assigned permissions in Fabric.

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

NewUser2025 — Wed, 10 Sep 2025 14:17:43 GMT

We have created Enterprise Application in Domain-2(Fabric) and where we need to assign Domain -1(Azure) client id to the Enterprise Application in Domain-2(Fabric), can you give me the step by step process

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

NewUser2025 — Thu, 11 Sep 2025 08:00:01 GMT

We have created the Enterprise Application in Domain-2(Fabric) we followed below steps
Step -1:

Step-2:

Step-3:

Step-4:

step-5:

Step-6:

Step-7: (We are struck in step7,Tell me the following steps)
How to assign Domain -1(Azure) client id to the Enterprise Application in Domain-2(Fabric) which is created above,Tell me the steps to assign client id

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

Anonymous — Thu, 18 Sep 2025 08:47:54 GMT

Hi NewUser2025,

Thank you for reaching out to the Microsoft fabric community forum.

please go through with the below documentation hope it may resolve your Issue:
Load data from Synapse to Fabric - Ben's Blog
Azure Synapse Analytics connector overview - Microsoft Fabric | Microsoft Learn

Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Team.

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

Anonymous — Mon, 22 Sep 2025 04:00:25 GMT

Hi NewUser2025,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

Anonymous — Fri, 26 Sep 2025 03:43:39 GMT

Hi NewUser2025,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

Regards,
Community Support Team.

Re: How to connect Multi Tenant connection in different domain fabric to synapse data pull

Anonymous — Wed, 01 Oct 2025 03:28:24 GMT

Hi NewUser2025,

I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.