Edit

Share via

Frequently asked questions for SQL database in Microsoft Fabric (preview)

  • FAQ

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.

  1. Execute the following query to check if the changes properly flow: 
    SELECT * FROM sys.dm_change_feed_log_scan_sessions;
  2. If the sys.dm_change_feed_log_scan_sessions DMV 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](../mirrored-database/overview.md)?

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

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.

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

Related content