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

[AnmolGan81]

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.

[v-prasare]

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.

[v-prasare]

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

[v-prasare]

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

[AnmolGan81]

Am exploring on the above, please allow me sometime.

[v-prasare]

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

[v-prasare · Accepted solution]

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