Reading and Writing data from Synapse to Fabric Warehouse

[Amit0167]

Hi,

I have an existing pipeline in ADF that populated my Raw layer data in ADLS2 and then SilverLayer Data in Synapse Dedicated Pool. I want to create a new task in same pipeline to populate a table in Fabric Warehouse.

I have created a Service Principle for Fabric and i tried creating a liniked service in ADF but i am getting an error

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com', Database: 'xxxxxxxxxxxxxxxxxxxxx', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed due to invalid authentication methods., SqlErrorNumber=18456,Class=14,State=1,

I tried this link but for the inbound Network Security, i am lost somewhere Set up and use private links for secure access to Fabric (Preview) - Microsoft Fabric | Microsoft Le...

any help is appreciated.

[AmitGarg · Accepted solution]

I have got the solution to my porblem now....

[v-cboorla-msft]

Hi @AmitGarg 

Glad that you were able to find some insights and appreciate if you could share the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thanks.

[AmitGarg]

Please find the image...

[v-cboorla-msft]

Hi @Amit0167 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience.

It would be helpful if you could you please share screenshots of any error messages you've encountered, along with your current pipeline configuration. This additional information will help me to understand and guide you in better way.

Thank you.