topic Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse? in Data Engineering

How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

AnmolGan81 — Thu, 12 Jun 2025 11:19:58 GMT

I have been trying to establish connectivity between dedicated Synapse pool and Azure fabric warehouse, in order to move data across synapse analytics to fabric warehouse, but I am unable to do so using service principle connectivity method, can someone guide me on end to end process on what roles permissions needs to be given on service principle so that I can test data movement using this connectivity method? or can redirect me to some proper microsoft blogs that expains this?

Currently I cant find any blogs that provides step by step guidelines to get connectivity to warehouse.

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

v-prasare — Fri, 13 Jun 2025 04:35:41 GMT

Hi AnmolGan81 ,To set up the service principal for connectivity between Synapse pool and Azure Fabric warehouse, ensure the following roles and permissions are assigned:

Admin or Member role in the Fabric workspace for full control access.
ADMINISTER DATABASE BULK OPERATIONS, INSERT, CREATE TABLE, and ALTER ON SCHEMA permissions for executing data movement commands.

For detailed step-by-step guidelines, you can refer to the Access control in Synapse workspace how to - Azure Synapse Analytics

Thanks,

Prashanth Are

MS Fabric community support

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

v-prasare — Tue, 17 Jun 2025 09:17:11 GMT

Hi AnmolGan81,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

AnmolGan81 — Tue, 17 Jun 2025 13:06:06 GMT

Am exploring on the above, please allow me sometime.

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

v-prasare — Mon, 23 Jun 2025 15:13:27 GMT

Thanks for the confirmation, did you get a chance to look at this? i request you to update workaroud you have followed and accept as answer if you have any progress on mentioned issue that your facing to help others in the community and find answers easily.

Thanks,

Prashanth Are

MS Fabric community support

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

v-prasare — Fri, 27 Jun 2025 04:29:02 GMT

Hi @AnmolGan81,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

Re: How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

v-prasare — Mon, 07 Jul 2025 10:20:41 GMT

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.