In PowerBI Desktop it looks like, that when you set DirectQuery or Import for one table from one source (e.g. SQL Server instance), all tables from this source are set to the same mode. It would be great to have to possibility to set some (e.g. Dimension) tables to Import and other (e.g. Facts) as Direct Query
2 Comments
- ivan_tamburicNew Member'+1. Similary like Tableau data blending.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Support Clustered Columnstore Tables with Nonclustered Primary Keys in Fabric Mirroring
Microsoft Fabric Mirroring should support source tables that use a Clustered Columnstore Index (CCI) when the table has a valid nonclustered primary key that can be used to uniquely identify rows. T...jasonhorner1 hour agoRegular VisitorNew3Views0likes0CommentsRequesting Security Control at Folder Level
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Fabric currently provides security controls at the Workspace and Item le...aravindhkdoss2 hours agoRegular VisitorNew5Views0likes0CommentsSupport Views in Microsoft Fabric Mirroring for Azure SQL Database and SQL Server
Microsoft Fabric Mirroring should support database views as mirrored objects, specifically for Azure SQL Database and SQL Server sources. Today, Fabric Mirroring primarily operates against physical ...jasonhorner2 hours agoRegular VisitorNew3Views0likes0CommentsConvert Classic Lakehouse to Schema-based
I created a lakehouse back in November last year. I believe it was while schema-enabled lakehouses were still in Preview. I understand that currently there isn't a way to convert the classic lakeho...hallmarke144 hours agoFrequent VisitorNew7Views0likes0Comments