Using DirectQuery
One of the most valuable features of Power BI is its deep support for real-time and streaming semantic models, with the ability to provide immediate visibility to business processes and events as this data is created or updated. As Power BI has become Microsoft’s flagship semantic modeling tool, with exclusive features not available in Azure Analysis Services or SQL Server Analysis Services, it has become feasible to design both DirectQuery models and composite models which utilize a mixture of DirectQuery and import storage modes on a per table basis.
The three most common candidates for DirectQuery or composite model projects are as follows:
- The data model would consume an exorbitant amount of memory if all tables were fully loaded into memory. Even if the memory size is technically supported by large Power BI Premium capacity nodes, this would be a very inefficient and expensive use of company resources, as most BI queries only access aggregated...
