Cancled: Navigating Large Data in PowerBI with Aggregate Tables and Dual Mode
Details
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.
Power BI
Business Intelligence & Data Warehousing
Database Professionals
SQL Server