jboarman
1 year agoRegular Visitor
Status:
Completed
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...
sukkaur
Microsoft Employee
1 year agoStatus changed:
Planned
to 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
Allow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara1 hour agoNew MemberNew3Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi5 hours agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K7 hours agoMicrosoft EmployeeNew22Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz11 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris11 hours agoAdvocate IINew1.4KViews27likes3Comments