Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: ✅ SQL database in Microsoft Fabric
You can connect to and query your SQL database in Fabric in all the same ways as Azure SQL Database.
You can connect to the SQL database using the web-based editor in the Fabric portal.
The web-based editor for SQL database in Fabric provides a foundational object explorer and query execution interface. The integrated Explorer menu lists all database objects.
A new SQL database in Fabric will automatically open into the web editor and an existing database can be opened in the web editor by selecting it in Fabric.
In Microsoft Fabric, the SQL analytics endpoint and SQL database are accessible through a Tabular Data Stream, or TDS endpoint, familiar to all modern web applications that interact with a SQL Server TDS endpoint. This is referred to as the SQL connection string within the Microsoft Fabric user interface.
To find the SQL connection string for your Fabric SQL database:
...
menu, select Settings then Connection strings. Fabric provides complete connection strings for providers including ADO.NET, JDBC, ODBC, PHP, and Go.To find the SQL connection string for the SQL analytics endpoint of your Fabric SQL database:
...
menu, then select Copy SQL connection string.You can easy connect to your SQL database with the Open in button in the Fabric portal query editor. Choose SQL Server Management Studio or the mssql extension with Visual Studio Code.
In SQL Server Management Studio (SSMS):
...
next to your SQL database.Data Source=
. For example, tcp:<servername>.database.fabric.microsoft.com,1433
. The Initial Catalog=
is the database name.Data Source=
into the Server name.Initial Catalog=
into the Connect to database text box.You can connect to your SQL database in Fabric with sqlcmd, just like any other SQL Database Engine product. Use Microsoft Entra ID authentication with the G
option. The Microsoft Entra authentication (-G
) require at least version 13.1.
In the following example, replace <server name>
with the long string of unique text that represents your SQL database in Fabric.
sqlcmd -S <your_server>.database.fabric.microsoft.com;1433 -G -d <your_database> -i ./script.sql
You can connect to your SQL database in Fabric with the bcp utility, just like any other SQL Database Engine product. Use Microsoft Entra ID authentication with the -G
option.
In the following example, replace <server name>
with the long string of unique text that represents your SQL database in Fabric.
bcp bcptest in "c:\temp\sample.dat" -S <your_server>.database.fabric.microsoft.com;1433 -d testdb -G -c
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Get started with SQL Database in Microsoft Fabric - Training
Learn how SQL Database in Microsoft Fabric works, the key concepts, and practical examples to help users SQL Database effectively as part of their analytics solutions.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a fabric data engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.