Forum Discussion
Connecting to Azure SQL Server from a Fabric Compute Notebook using Managed Identity
Hi hkaushik ,
I want to personally thank nilendraFabric for your active participation and the valuable solutions you have shared in the community forum. Your contributions truly make a significant impact.
Thank you for trying the provided approach. Since it did not resolve the issue, I kindly recommend raising a support ticket. This will enable a dedicated team to investigate and provide you with a resolution.To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!
Thanks,
Pallavi G.
Hi,
We have been using MSI in Azure Synapse for every possible connection and now we migrated to Fabric. Still struggling to connect to our SQL DBs in Fabric Notebook, tried every solution given but it never worked for me. Could someone update here if it worked or there is any workaround.
Other limitation with Fabric is when using Lakehouse tables in copy activity of pipeline to copy some data from lakehouse to SQL DBs Tables, it does not offer source query option(widly used in ADF and Synapse Pipelines) , so we cannot apply any logic in copy activity and if we want to replicate the select logic in Notebook, we are not able to connect to SQL DB in notebook. We cannot use userid password for authentication MSI/WSI is only option for us.
Please suggest.