Table of Contents
Preface
Part 1: Architecture, Bottlenecks, and Performance Targets
1
Setting Targets and Identifying Problem Areas
Defining good performance
Reporting performance goals
Setting realistic performance targets
Considering areas that could slow you down
Connecting data sources
Import mode
DirectQuery mode
Live connection mode
DirectLake mode
Summary
2
Exploring Power BI Architecture and Configuration
Understanding data connectivity and storage modes
Choosing between Import, DirectQuery, and Direct Lake mode
Import mode
DirectQuery mode
Direct Lake mode
Live connection
Deploying Power BI gateways
How gateways work
Good practices for gateway performance
Sizing gateways
General architectural guidance
Capacities
Planning data and cache ...
Get Microsoft Power BI Performance Best Practices - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
