Study guide

The Power BI Ecosystem

Microsoft Power BI Data Analyst PL-300

Track your progress as you read

Finished sections get a check mark.

1 Introduction

About the PL-300 Exam The Power BI Ecosystem

2 Chapter 1: Get or Connect to Data

1.1 Data Source Types and Connections 1.2 Storage Modes: Import, DirectQuery, and Direct Lake 1.3 Data Source Settings and Parameters

3 Chapter 2: Profile and Clean the Data

2.1 Data Profiling in Power Query 2.2 Resolving Errors, Nulls, and Data Quality Issues 2.3 Data Types and Type Detection

4 Chapter 3: Transform and Load the Data

3.1 Column Transformations and Data Types 3.2 Grouping, Aggregating, Pivoting, and Unpivoting 3.3 Merge Queries, Append Queries, and Relationship Keys 3.4 Query Folding and Load Performance

5 Chapter 4: Design and Implement a Data Model

4.1 Star Schema Design 4.2 Relationships, Cardinality, and Cross-Filter Direction 4.3 Table and Column Properties 4.4 Calculated Columns and Calculated Tables

6 Chapter 5: Create Model Calculations with DAX

5.1 DAX Fundamentals and Measures 5.2 The CALCULATE Function 5.3 Time Intelligence Measures 5.4 Statistical Functions, Semi-Additive Measures, and Calculation Groups 5.5 Essential DAX Patterns and Functions Reference

7 Chapter 6: Optimize Model Performance

6.1 Performance Analyzer and DAX Query View 6.2 Model Size Reduction and Cardinality Management 6.3 DAX Optimization Patterns

8 Chapter 7: Create Reports

7.1 Visual Types and Selection 7.2 Visual Formatting and Conditional Formatting 7.3 Copilot in Power BI Reports 7.4 Report Page Configuration and Slicers

9 Chapter 8: Enhance Reports for Usability and Storytelling

8.1 Bookmarks, Navigation, and Drillthrough 8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility 8.3 Export Settings and Automatic Page Refresh

10 Chapter 9: Identify Patterns and Trends

9.1 The Analyze Feature and AI Visuals 9.2 Using Copilot to Summarize the Semantic Model 9.3 Advanced Analytics Patterns

11 Chapter 10: Create and Manage Workspaces and Assets

10.1 Workspaces, Apps, and Content Distribution 10.2 Subscriptions, Alerts, and Semantic Model Refresh 10.3 Dashboards and Advanced Distribution

12 Chapter 11: Secure and Govern Power BI Items

11.1 Row-Level Security (RLS) 11.2 Sensitivity Labels, Item Access, and Governance 11.3 Deployment Pipelines and Content Lifecycle

The Power BI Ecosystem

Key Takeaways Explain This Topic AI

Power BI Desktop is the free authoring tool for building reports and data models.

Power BI Service (app.powerbi.com) is the cloud platform for sharing, collaboration, and governance.

Power BI Mobile enables on-the-go access to reports and dashboards.

Power BI Report Server provides on-premises report hosting for regulated industries.

Microsoft Fabric integrates Power BI with a unified analytics platform including lakehouses and data pipelines.

Last updated: June 2026

Quick Answer: Power BI is a suite of tools — Desktop for authoring, Service for sharing and governance, Mobile for on-the-go access, and Report Server for on-premises hosting. In 2026, Power BI is deeply integrated with Microsoft Fabric , a unified analytics platform that combines data engineering, data science, and business intelligence into one SaaS experience.

Understanding the complete Power BI ecosystem is essential for the PL-300 exam because questions often reference specific tools, services, and their appropriate use cases.

  • Power BI Components
  • Power BI Desktop

Power BI Desktop is a free Windows application that serves as the primary authoring tool for Power BI content. It is where data analysts spend most of their time.

  • Feature Description
  • Power Query Editor Connect to 100+ data sources, transform and clean data using M language
  • Data Model Design star schemas, create relationships, write DAX measures
  • Report Canvas Build interactive visualizations with 30+ built-in visual types
  • DAX Query View Write and test DAX queries directly against the model
  • Copilot AI-powered assistance for creating visuals and writing DAX

Power BI Desktop files use the .pbix extension and can be published to the Power BI Service.

Power BI Service

The Power BI Service (app.powerbi.com) is a cloud-based SaaS platform for sharing, collaborating on, and governing Power BI content.

Key capabilities:

  • Workspaces — Organized containers for reports, dashboards, datasets, and dataflows
  • Apps — Bundled collections of dashboards and reports distributed to users
  • Dashboards — Single-page canvases with pinned tiles from multiple reports
  • Semantic Models — Published datasets that serve as shared data sources
  • Dataflows — Cloud-based ETL processes using Power Query Online
  • Deployment Pipelines — Promote content through dev, test, and production stages
  • Gateways — Bridge on-premises data sources with the cloud service
  • Scheduled Refresh — Automate data updates on a configurable schedule
  • Power BI Mobile

Power BI Mobile apps are available for iOS, Android, and Windows devices. They provide:

  • View and interact with reports and dashboards
  • Receive data-driven alerts
  • Annotate and share reports
  • Scan QR codes to access specific reports
  • Offline access to favorites
  • Power BI Report Server

Power BI Report Server is an on-premises solution for organizations that must keep data behind their firewall. It supports:

  • Power BI reports (.pbix)
  • Paginated reports (.rdl)
  • Mobile reports
  • KPI dashboards

Exam Tip: Report Server is less commonly tested but may appear in questions about deployment choices for organizations with strict data residency requirements.

Microsoft Fabric Integration

Microsoft Fabric is a unified analytics platform that brings together data engineering, data warehousing, data science, real-time analytics, and business intelligence. Power BI is the visualization and analytics layer of Fabric.

Key Fabric Concepts for the PL-300

  • Concept Description
  • OneLake A single, unified data lake for all Fabric workloads
  • Lakehouse Combines data lake flexibility with data warehouse structure
  • Direct Lake New storage mode that reads data directly from OneLake Parquet files
  • Dataflows Gen2 Next-generation cloud ETL using Power Query Online
  • Semantic Models The new name for Power BI datasets in the Fabric era
  • Fabric Workspaces Unified workspaces shared across all Fabric workloads
  • Direct Lake Mode

Direct Lake is a game-changing storage mode introduced with Microsoft Fabric:

  • Reads data directly from Parquet/Delta files in OneLake
  • Provides Import-like performance without copying data into the model
  • Eliminates the need for data refresh in many scenarios
  • Falls back to DirectQuery if the data volume exceeds memory limits

Only available with Fabric capacity (F or P SKUs) Direct Lake = Import Speed + DirectQuery Freshness \text{Direct Lake} = \text{Import Speed} + \text{DirectQuery Freshness} Direct Lake = Import Speed + DirectQuery Freshness

Storage Modes Comparison

  • Feature Import DirectQuery Direct Lake
  • Data Location Copied into model Stays at source OneLake (Parquet)
  • Performance Fastest Depends on source Near-Import speed
  • Data Freshness At last refresh Real-time Near real-time
  • Model Size Limit 1 GB (shared) / 400 GB (Premium) No limit Capacity dependent
  • Refresh Required Yes No No (auto-sync)
  • Best For Small-medium datasets Large/real-time data Fabric environments
  • Licensing Overview
  • License Features
  • Power BI Free Desktop authoring, My Workspace only
  • Power BI Pro Sharing, collaboration, 1 GB model limit
  • Power BI Premium Per User (PPU) Pro + Premium features (100 GB limit)
  • Power BI Premium Per Capacity Org-wide, paginated reports, XMLA, 400 GB
  • Fabric Capacity (F SKUs) All Premium features + Fabric workloads
  • Authoring vs. Consumption — a Recurring Exam Theme

Many PL-300 questions hinge on knowing which tool performs which task . Use this division as a mental model when a scenario asks where an action should happen:

  • Task Correct Tool
  • Build the data model, relationships, and DAX measures Power BI Desktop
  • Transform data with Power Query before load Power BI Desktop (or Dataflows Gen2 for shared ETL)
  • Schedule refresh, manage credentials, configure RLS roles Power BI Service
  • Distribute content to an organization Power BI Service (apps)
  • Consume reports with data alerts on the go Power BI Mobile
  • Host reports fully on-premises behind a firewall Power BI Report Server

A common trap: questions describe a governance or sharing action (scheduled refresh, RLS membership, app publishing) and offer Desktop as a tempting distractor. Those operations live in the Service , while model authoring lives in Desktop .

Exam Tip: Dashboards exist only in the Service — you cannot build a dashboard in Desktop. A report (multi-page, built in Desktop) is different from a dashboard (single-page canvas of pinned tiles, built in the Service). Confusing the two is a frequent exam error.

On the Exam

The PL-300 frequently tests:

  • When to use Desktop vs. Service for specific tasks
  • Choosing between Import, DirectQuery, and Direct Lake
  • Understanding workspace roles and sharing mechanisms
  • Knowing which features require Pro vs. Premium licensing

Loading diagram... Power BI Architecture Overview