Applies to: ✅ SQL database in Microsoft Fabric
This article answers frequently asked questions about SQL database in Microsoft Fabric.
Connectivity
How do I connect to SQL database in Fabric?
You can connect to SQL database in Fabric in the same ways you connect to Azure SQL Database. For more information, see Connect to SQL database in Fabric.
About SQL database data in OneLake
Is there a staging or landing zone for SQL database data replication into OneLake? If so, is it outside of OneLake?
For the data replicated into OneLake, a landing zone stores both the snapshot and change data, to improve performance when converting files into delta verti-parquet.
How long does it take to replicate inserts/updates/deletes into OneLake?
Near real-time latency.
Do you support replicating of views, transient or external tables into the OneLake?
No. Currently, only replicating regular tables are supported.
Can Power BI reports on SQL database in Fabric use direct lake mode?
Yes. In OneLake, the SQL database tables are all v-ordered delta tables.
How do I know Fabric is replicating data from SQL database to OneLake?
Use the following database level checks using Dynamic Management Views (DMVs) and stored procedures to validate configuration. Contact support if troubleshooting is required.
- Execute the following query to check if the changes properly flow:
SELECT * FROM sys.dm_change_feed_log_scan_sessions; - If the
sys.dm_change_feed_log_scan_sessionsDMV doesn't show any progress on processing incremental changes, execute the following T-SQL query to check if there are any problems reported:SELECT * FROM sys.dm_change_feed_errors;
How to stop/disable replication of data from SQL database in Fabric to OneLake?
For SQL database in Fabric, the replication of data to OneLake cannot be disabled.
Are system objects such as system views and dynamic management views the same as Fabric database mirroring?
Yes, with the exception of objects that disable the replication.
Security
Is data ever leaving the customers Fabric tenant?
No.
Is data staged outside of a customer environment?
No. Data isn't staged outside of customer environment, it's staged in the customer's OneLake.
Cost management
What are the costs associated with SQL database in Fabric?
During preview, there's no cost for SQL database in Fabric.
Monitoring
How do I monitor the performance of SQL database in Fabric?
Use the Performance Dashboard, with rich information on most expensive/frequent queries, CPU utilization, and alerts on performance critical states. For more information, see Performance Dashboard for SQL database in Fabric.
Reliability
Does SQL database in Fabric support availability zones?
Yes. For more information, see Fabric availability zone support.
Licensing
Is SQL database in Fabric currently free, and if so, for how long?
SQL database in Fabric completely is free until February 1, 2025. After this date, compute and data storage charges begin. Backup billing starts on March 1, 2025.
What are licensing options for SQL database in Fabric?
A Power BI Premium, Fabric Capacity, or Trial Capacity is required. For more information on licensing, see Microsoft Fabric licenses.
Is SQL database in Fabric billed with Fabric capacity or with Azure capacity?
Billing for SQL database in Fabric is structured according to the Fabric Capacity Model.
Availability
Where is SQL database in Fabric available?
SQL database in Fabric is available in regions where Microsoft Fabric is available. For more information, see Fabric availability. Mirroring of SQL database in Fabric is available in Fabric regions that support mirroring.
Troubleshooting
I tried to create a database but got the error message "SQL database failed to create." What should I do?
Make sure that you Enable SQL database in Fabric using Admin Portal tenant settings. If you don't, users who try to create a new SQL database will receive an error message "SQL database failed to create."