Analysis Services (either the integrated workspace in Power BI or on a SQL Server) lets you interact with the data via:
- DirectQuery - runtime request transformed into SQL statements against data source
- Import Modes - runtime request applied against cached in-memory VertPaq data imported (processed)
PowerBI and Azure Analysis Services support "composite" models, where some tables can use DirectQuery and others Import.
Visual Studio Analysis Services projects (2022) don't let you do that - you have to pick 1 or the other for the model.
Is there a way to trick the model into being a composite model? e.g., maybe for tables that are very large/non compressible or need real time data Direct Query and others Import Mode.