Fabric SQL database has to support fully Power BI

[pmscorca]

Hi,

I think it is very importante that the Fabric SQL database workload could support fully Power BI, also with Direct Lake mode, like it happens for a lakehouse or a warehouse. Fabric SQL database should be fully integrated in the Fabric platform.

Thanks

[akatesmith]

Hi @pmscorca , 

SQL database in Fabric is currently in public preview on the Fabric platform.  It is fully integrated with the Fabric platform - from OLTP SQL engine to the analytics endpoint to the lakehouse.  

Here is the documentation for our product: 

SQL database Overview (Preview) - Microsoft Fabric | Microsoft Learn

And some additional information about creating reports: 

Create reports on your SQL database in Power BI - Microsoft Fabric | Microsoft Learn

You can leverage direct lake query mode by connecting to the SQL analytics endpoint, which is automatically populated when you create a SQL database in Fabric.  This document contains more information:

https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview 

--Kate