Power BI Composite and Hybrid Models
summary
Shows how to combine import and DirectQuery so a billion-row web‑hits fact stays in source while a pre‑aggregated import table serves most visuals, cutting a 13s query to a few hundred ms; demos using DAX Studio profiler to diagnose an aggregation mismatch (fixed by changing a count to count of load_duration) and building DQ over Power BI datasets plus hybrid tables with incremental refresh to get near‑real‑time data. Notes preview limits: three‑dataset chains, high‑cardinality cross‑island joins slow, and RLS isn’t enforced cross‑island.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:16Data model types overview
- 4:06Pros and cons of model types
- 7:54Composite models in practice
- 13:34Configuring aggregations
- 17:21Debugging and optimizing
- 23:19Centralization and reuse
- 34:07Advanced composite model usage
- 40:56Hybrid tables and refresh
- 47:59Conclusion and Q&A
related talks
51mPower BI and Big Tables
45mAzure DW and Power BI, reporting at the speed of light!
51mAggregations in Power BI
51mOptimising DAX fusion - Power BI
51mTroubleshooting Power BI Report Performance
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
30mEmpower every BI professional to do more with Fabric
58mPower BI for the Developer