Enable Connection from Fabric Notebook to Fabric SQL Database
The core issue is the inability to directly access Microsoft Fabric SQL Databases from within Fabric Notebooks, despite the availability of JDBC and ODBC connection strings. The built-in notebook authentication token library appears to be missing Fabric SQL as an option.
It does not currently appear possible (or at least not documented how) to access a Fabric SQL Server Database from within a Fabric Notebook. I see JDBC and ODBC connection strings, but these don't work apparently because the library to create authentication tokens is missing Fabric SQL as an option.
Current Impact
1. Enterprises must create complex workarounds ("Rube Goldberg architectures") to establish basic data flows that leverage SQL Server
2. The platform fails to deliver on its "unified" promise, leading to a loss of faith in the Fabric brand
3. SQL Server's established strengths are not being leveraged effectively, further eroding trust that Fabric can deliver on enterprise data needs
Summary
This is a critical feature request that highlights a significant gap in Microsoft Fabric's platform integration. The inability to easily access Fabric SQL Databases from Fabric Notebooks undermines the platform's unified vision and creates unnecessary complexity for enterprise users. The request is well-justified, technically feasible, and would bring significant value to the platform.
4 Comments
- fbcideas_migusrNew MemberStatus added:Under Review
- dlevy
Microsoft Employee
Status changed:Under ReviewtoPlanned - sukkaur
Microsoft Employee
Status changed:PlannedtoPlannedjboarman - Our team is working to get Notebook integration with SQL database in Fabric. Our phase I of this feature is out - it's called magic T SQL. Now just add the below line in a cell and connect to your database easily-
%%tsql -artifact sqldb1 -type SQLDatabase -bind df2
please check out this document for further details - Run T-SQL code in Fabric Python notebooks - Microsoft Fabric | Microsoft Learn
Thanks
Sukhwant
- sukkaur
Microsoft Employee
Status changed:PlannedtoCompleted
Recent ideas
Multi Select formatting for Matrix Visual
Description Currently, Power BI Matrix visuals require report authors to configure alignment and conditional formatting for each column individually. When using Field Parameters, renaming a column o...mnkumar249155 minutes agoNew MemberNew2Views0likes0CommentsDynamic Batch Count in Data Factory Pipelines (FOREACH ACTIVITY)
Currently, in Data Factory, the ForEach activity requires a static batch count when executing in parallel mode. However, this fixed value does not always align with dynamic workloads, leading to inef...raym855 hours agoAdvocate INew1.4KViews10likes2CommentsDeployment Pipelines: preserve/override schedules per environment (no overwrite on deploy)
When deploying from Dev/Non-Prod to Prod, the target’s pipeline schedule is overwritten. Please add deployment rules (or an opt-out) so schedules can be environment-specific without showing as drift ...JP89918 hours agoKudo CommanderUnder Review4KViews67likes22CommentsSupport Power BI connection with Salesforce community URL
Before Salesforce changed customer links to my.site.com our customers were able to connect salesforce with power bi and use their own logins in Power BI and maintain the security from Salesforce. No...gilmore_staci14 hours agoHelper IIINew5Views1like0CommentsShow all email recipients when sending subscription
When a subscription is sent out, the recipients can only see themselves and not everyone who received that subscription. We would like the subscription to show everyone who received that subscription...jhawkfan14 hours agoNew MemberNew5Views0likes0Comments