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
1 Comment
- akatesmith
Microsoft Employee
Status changed:NewtoCompletedHi 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
Recent ideas
Support Service Principal for T‑SQL Notebook Execution
Make T‑SQL notebook execution fully compatible with Service Principals by removing or replacing internal OBO calls that reject SPNs. When pipelines or automated runs execute Fabric notebooks usin...garddolau8 hours agoAdvocate IVNew283Views10likes1CommentDeployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v8 hours agoCommunity ChampionNew6.3KViews149likes19CommentsExpose Real-Time (KQL) Dashboard Usage Through Activity Events and Audit Logs
Microsoft Fabric currently inventories Real-Time (KQL) Dashboards, allowing administrators to discover and manage them through inventory metadata and workspace scanning. However, there is no correspo...KimY12 hours agoFrequent VisitorNew5Views0likes0CommentsNative Git Integration in Power BI Desktop using PowerShell (Developer Mode for PBIP projects)
With the introduction of the PBIP (Power BI Project) format, Power BI has taken a huge step toward modern development workflows, including proper version control and CI/CD practices. However, today ...matheusmg_2012 hours agoNew MemberNew544Views3likes1Comment