Navigating Large Data in Power BI - Chen Hirsh
How can you run reports in PowerBI when your tables are too large for import mode, but direct mode queries are too slow?
With Power BI aggregate tables and dual mode you can run most of your workload on small, aggregated data in import mode, while allowing user to drill into the full tables in direct query if needed.