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 au...

Databases

Databases | SQL Database

sukkaur

Microsoft Employee

1 year ago

Status changed:

Planned

jboarman - 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

Recent ideas

Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...
vvargasv
Microsoft Employee
1 day ago
New
Views
0likes
Comments
Conditional Formatting on Matrix Rows
Currently, the matrix visual only supports conditional formatting on a per-field basis. If you want to apply the same formatting for an entire row of values you need to set it once for each field, an...
wcarter
Advocate III
2 days ago
New
Views
0likes
Comments
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...
Jarrinf
Frequent Visitor
2 days ago
New
Views
3likes
Comments
Add REST API to Take Ownership of Fabric Pipelines
When using service account to automatically deploy Fabric pipelines from Dev workspace to upper environments, the owner of pipelines in target envionment remain unchanged. In some situations, per...
VickyPeng
Regular Visitor
2 days ago
New
Views
5likes
Comments
Update the 'Users can set up email subscriptions' in Fabric Admin Portal to specific groups
I want to be able to allow a specific group of users to set up email subscriptions. In my admin portal view I only get the following Can this be updated to allow specific user groups? ...
Chart68
New Member
2 days ago
New
Views
1like
Comment

Enable Connection from Fabric Notebook to Fabric SQL Database

Dynamic current-period defaults for separate Year and Month slicers

Conditional Formatting on Matrix Rows

About "Download SQL database project" and fix the downloaded project

Add REST API to Take Ownership of Fabric Pipelines

Update the 'Users can set up email subscriptions' in Fabric Admin Portal to specific groups