Forum Discussion
T‑SQL Magic Command (%%tsql) Error in Microsoft Fabric Notebook on Fabric SQL Database
v-kpoloju-msft I have alredy tried below cmd, this is also not working,
%%tsql -artifact sqldb1 -type SQLDatabase -session SELECT 1
For SSL trust validation, Is there any documentation what fabric or tenant team need to change?
Hi khanjaved,
Thank you for confirming that the session based %%tsql command also fails with the same SSL error.
In Microsoft Fabric, notebook connections to SQL Database use secure, platform-managed connectivity where authentication, encryption, and certificate validation are handled internally by the Fabric service. There are no tenant-level settings available to manually configure or override SSL certificate trust.
Since you have confirmed the same command works in another tenant but fails in this tenant even with newly created workspaces, SQL databases, and notebooks this helps isolate the behaviour to the tenant environment rather than notebook syntax or artifact configuration. In this case, it would be appropriate to engage your internal Microsoft support channel or create a support request so the Fabric team can further investigate the tenant-specific runtime and connectivity behaviour.
Thank you again for using the Microsoft Fabric Community Forum.
Hi khanjaved,
Just checking in to see if there has been any update on this issue after engaging the Microsoft support channel. Could you please confirm whether the issue has been resolved? If it is resolved, we would appreciate it if you could share the resolution or key insights here, as it may help other community members facing similar issues.
Thank you.
Hi v-kpoloju-msft , I did not go to Microsoft support, Instead I tried using pyspark way and it wroked.
Hi khanjaved,
Thank you for the update. Glad to hear that the PySpark approach worked successfully. If you have any further questions please feel free to reach out to us. we will be happy to help.
Thank you for sharing your findings with the community.