Power BI and Big Tables
summary
Explains when to use import vs DirectQuery and how to combine them with DAX Studio, the XMLA endpoint and Tabular Editor to manage partitions and scripts. Shows DirectQuery taking ~1,000 ms vs import under 200 ms on a 60,000‑row demo, notes VertiPaq segment sizes (1M in Desktop, 8M in large models), ~10:1 compression, and Power BI limits (Pro ~1–10 GB, Premium up to 400 GB). Demonstrates incremental refresh, composite/dual mode, hybrid partitions and aggregation tables; warns about query injection when mixing imported rows with DirectQuery.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:33Big data challenges in Power BI
- 4:00DirectQuery with big tables
- 15:11Storing results for faster reports
- 21:35Import mode for performance
- 24:05Tables too large for Power BI
- 28:45Incremental refresh for large datasets
- 33:24Demo: Incremental refresh setup
- 40:26Composite models with storage modes
- 44:41Dual mode for hybrid access
- 47:13Hybrid mode: real-time and historical
- 50:24Summary and Q&A
related talks
51mPower BI Composite and Hybrid Models
48mDon't be scared with Hybrid, they are only tables…
50mPower BI + Azure Synapse Analytics: Beginning your journey
50mPower BI Incremental refresh made simple.
25mFrom Data Warehouse To Self-service BI: Our Journey To Data Mesh
18mEmpowering Business Through Data
51mSupercharge Power BI with Azure Synapse Analytics
54mData Visualization with Power View and the Tabular Model