1.1 — Plan and Configure the Analytics Environment
DP-600 Domain 1 · Skill 1.1
What You Need to Know
Before building anything, an analytics engineer chooses the capacity, the tenant and workspace settings, and the gateways the solution needs. Exam questions here are usually about requirements: which SKU, which setting, which gateway.
Capacity SKUs
| Fact | Detail |
|---|---|
| F SKUs | Fabric capacities from F2 to F2048. The number is the capacity units (CU). You can pause, resume and scale them in Azure |
| F64 threshold | From F64 up, users with a free license can view Power BI content shared from the capacity. On smaller SKUs, viewers need Pro or PPU |
| Semantic model limits | Grow with the SKU, for example maximum memory per model and Direct Lake guardrails (rows and files per table) |
| Smoothing and throttling | Background jobs are smoothed over 24 hours and interactive ones over shorter windows. A capacity that runs over its limit for long enough is throttled (delays, then rejections) |
| Trial | A 60-day trial capacity for evaluation |
Manage capacity by assigning workspaces to it, scaling or pausing it, watching it in the Capacity Metrics app, and setting capacity-level options such as the XMLA endpoint (Read Write) and Spark pool permissions.
Admin portal and tenant settings
- Tenant settings (Fabric admin) switch features on for the whole organization or for named security groups. Examples: Users can create Fabric items, Git integration, service principal API access, export to Excel, sensitivity labels and certification.
- Many settings can be delegated to capacity admins or domain admins, so business units can manage them.
- Workspace settings (workspace Admin): the license mode or capacity, Spark settings, Git integration, OneLake settings, and the default storage format for semantic models.
Recommend the narrowest setting that meets the need. For example, enable a feature for one security group instead of the whole tenant.
Choose a data gateway
| Gateway | Use it for | Notes |
|---|---|---|
| On-premises data gateway (standard mode) | Shared, organization-wide access to on-premises sources (SQL Server, file shares) for semantic models, dataflows and pipelines | Installed on a server inside your network; clusters give high availability; many users share it |
| On-premises data gateway (personal mode) | One person refreshing their own Power BI semantic models | Power BI only, can't be shared, no DirectQuery |
| Virtual network (VNet) data gateway | Azure sources behind private endpoints or in a VNet | Managed by Microsoft, nothing to install; runs inside your Azure VNet |
| No gateway | Public cloud sources | Cloud connections only |
Custom report theme
- A report theme is a JSON file with colors, fonts and default visual formatting. You create it in Power BI Desktop (View > Themes > Customize current theme) or write the JSON yourself.
- Save the theme JSON and reuse it, or put it into a template (.pbit), so every new report starts with the corporate look.
Key Concept: Free-license viewing starts at F64. Gateways depend on where the source is: on-premises means the standard gateway, private Azure means a VNet gateway. Turn tenant settings on for security groups, not for everyone, when least privilege is asked for.
Exam Traps
- Choosing F32 for 2,000 free-license report viewers (they would each need Pro)
- Using a personal-mode gateway for a team's shared semantic models or dataflows
- Installing an on-premises gateway for an Azure SQL database that has a private endpoint, when a VNet gateway is designed for that
- Enabling a tenant setting for the entire organization when only one team needs it
Check your understanding
Practice Scenario
A company will publish Power BI reports from one workspace to 1,500 employees who have only free Fabric licenses. The company doesn't want to buy individual Pro or Premium Per User licenses for these viewers. What is the smallest capacity that meets the requirement?
Log in to save your progress.
Sources
- Microsoft Fabric concepts and licenses, Microsoft Learn
- What is the admin portal?, Microsoft Learn
- What is an on-premises data gateway?, Microsoft Learn
- What is a virtual network data gateway?, Microsoft Learn
- Use report themes in Power BI Desktop, Microsoft Learn