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
- '+1. Similary like Tableau data blending.
- Status added:Needs Votes
Recent ideas
Fabric REST API endpoint for dataflow transactions should GET *sortable* results for a time-range
Dataflow refresh APIs seem to be the buggiest; the list of transactions on a GET for Fabric-dataflow, are not sorted by the latest. OData query options such as $top, $filter, $orderby do not work wit...
