All 4 domains
11 official functional groups
55–75 hrs suggested study
-
Domain 01
25–30%
This domain covers getting data into Power BI and shaping it. It covers connecting to data sources, choosing between Import, DirectQuery and DirectLake, profiling and cleaning data, and transforming and loading it with Power Query, including building fact and dimension tables.
Inside this domain
- Get or connect to data sources and choose a storage mode
- Profile and clean the data
- Transform and load the data with Power Query
Watch for Import for live data
- Functional groups
- 3
Read the domain guide →
-
Domain 02
25–30%
This domain covers building the semantic model. It covers designing and implementing a star-schema data model, creating calculations with DAX, and optimizing model performance.
Inside this domain
- Design and implement a data model
- Create model calculations by using DAX
- Optimize model performance
Watch for Bidirectional everywhere
- Functional groups
- 3
Read the domain guide →
-
Domain 03
25–30%
This domain covers turning the model into insight. It covers creating reports and choosing visuals, enhancing reports for usability and storytelling, and identifying patterns and trends, including Copilot and AI features.
Inside this domain
- Create reports
- Enhance reports for usability and storytelling
- Identify patterns and trends
Watch for Filter instead of drillthrough
- Functional groups
- 3
Read the domain guide →
-
Domain 04
15–20%
This domain covers deploying and governing Power BI. It covers creating and managing workspaces and assets, distribution, refresh and gateways, and securing items with workspace roles, item access, row-level security and sensitivity labels.
Inside this domain
- Create and manage workspaces and assets
- Secure and govern Power BI items
Watch for Separate reports per group
- Functional groups
- 2
Read the domain guide →
Domain names, weights and functional groups come from Microsoft's official outline (Skills measured as of 20 April 2026 (current)). Question counts and study hours are editorial planning estimates, not official figures. Last reviewed October 2026.