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 Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi8 minutes agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K2 hours agoMicrosoft EmployeeNew19Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz6 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris6 hours agoAdvocate IINew1.4KViews27likes3CommentsBring Back separating Power BI artifacts on a per web page basis
Previously, the ability to have different artifacts open on different web tabs was enabled. This was beneficial if you wanted to differentiate what environments you were in, working across three diff...zoe-dean8 hours agoNew MemberNew54Views8likes0Comments