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