What is the PL-900 exam and who is it for?
The PL-900 exam tests foundational knowledge of Microsoft Power Platform -- the suite of low-code tools including Power BI for analytics, Power Apps for application development, Power Automate for workflow automation, and Power Virtual Agents (now Copilot Studio) for chatbots. It targets business users, citizen developers, functional consultants, and IT professionals who want to demonstrate awareness of what Power Platform can do before pursuing role-specific Power Platform certifications.
The Microsoft Certified: Power Platform Fundamentals credential, earned by passing the PL-900 exam, covers the business value and capabilities of Microsoft Power Platform -- one of the fastest-growing segments in Microsoft's portfolio. Power Platform enables organizations to build custom applications, automate workflows, analyze data, and create AI-assisted chatbots with minimal or no traditional coding required.
The platform has grown from an internal Microsoft productivity experiment into a commercial force that Forrester Research estimated contributed $23.1 billion in value to the global market in 2023. With over 30 million monthly active users as of 2024 and a commitment from Microsoft to embed Copilot AI capabilities throughout the platform, Power Platform skills are increasingly valued across both technical and non-technical roles.
The PL-900 is the entry point for a certification path that includes role-specific associate credentials: Power BI Data Analyst (PL-300), Power Apps Developer (PL-400), Power Automate RPA Developer (PL-500), and Power Platform Solution Architect (PL-600). Understanding the fundamentals credential positions candidates to choose the right specialty path based on their specific role.
PL-900 Exam Overview
The PL-900 exam contains 40-60 questions with 60 minutes allowed. The passing score is 700 out of 1000. All questions are knowledge-based -- no performance-based labs. Question types include multiple choice, multiple select, and drag-and-drop.
| Domain | Approximate Weight |
|---|---|
| Describe the business value of Microsoft Power Platform | 15-20% |
| Identify foundational components of Microsoft Power Platform | 15-20% |
| Demonstrate the capabilities of Power BI | 15-20% |
| Demonstrate the capabilities of Power Apps | 15-20% |
| Demonstrate the capabilities of Power Automate | 15-20% |
| Demonstrate the complementary value of Microsoft Power Platform | 15-20% |
Objectives current as of 2024. Verify at learn.microsoft.com/certifications/power-platform-fundamentals.
The PL-900 follows the same format as other Microsoft fundamentals exams -- conceptual knowledge tested through scenario recognition rather than hands-on configuration. Most candidates with basic computer literacy need 20-30 hours of preparation.
Domain 1: Business Value of Power Platform (15-20%)
Why Power Platform Exists
Traditional software development cycles are slow and expensive. A business process change that requires a custom application, workflow automation, or data dashboard might wait months in an IT queue before development resources are allocated. Power Platform addresses this gap by enabling citizen developers -- business users with process knowledge but limited coding skills -- to build solutions themselves.
Low-code development -- application development that uses visual, drag-and-drop interfaces and configuration rather than traditional programming, enabling people without software development backgrounds to create functional solutions.
"The digital skills gap is real. Organizations have thousands of business experts who understand processes deeply but cannot write code. Power Platform inverts that problem -- it meets people where their expertise is and lets the business logic drive the solution, not the technology." -- Charles Lamanna, Corporate Vice President of Power Platform at Microsoft, from the Microsoft Business Applications Summit 2023
Power Platform Components
The PL-900 tests understanding of each component's purpose and the scenarios each addresses:
| Component | Primary Capability | Typical User |
|---|---|---|
| Power BI | Data visualization and analytics | Analysts, managers |
| Power Apps | Custom application development | Citizen developers |
| Power Automate | Workflow automation | Business process owners |
| Copilot Studio (Power Virtual Agents) | AI chatbot creation | Business analysts |
| Power Pages | External-facing business websites | Business/IT |
Microsoft Dataverse -- the underlying data platform for Power Platform. It provides a secure, scalable data store with built-in business logic, security, and compliance. Dataverse stores data in tables (similar to database tables) and includes built-in entities for common business objects (accounts, contacts, opportunities, cases).
Connectors
Connectors bridge Power Platform and external data sources and services. Over 1,000 connectors are available, including:
- Standard connectors: Available to all Power Platform plans (SharePoint, Excel, Outlook, Teams)
- Premium connectors: Require specific Power Platform licenses (Salesforce, ServiceNow, SQL Server)
- Custom connectors: Organizations can build connectors to internal systems using REST APIs and OpenAPI definitions
Domain 2: Foundational Components (15-20%)
Microsoft Dataverse Architecture
Dataverse provides more than data storage. The PL-900 tests awareness of:
Tables (formerly called Entities) contain data organized in rows and columns. Standard tables (Account, Contact, Lead) come pre-built. Custom tables support unique business data.
Relationships between tables:
- One-to-many: One account with multiple contacts
- Many-to-many: Multiple opportunities associated with multiple products
- One-to-one: Less common, links two records uniquely
Business rules enforce data validation and field logic without requiring code -- marking fields as required based on other field values, calculating field values automatically.
Dataflows import and transform data from external sources into Dataverse tables on a scheduled basis using Power Query Online, the same query engine used in Power BI and Excel.
The Power Platform Admin Center
The Power Platform Admin Center (admin.powerplatform.microsoft.com) provides centralized governance for Power Platform environments, including:
- Environments: Isolated containers for apps, flows, and data. Organizations use separate environments for development, testing, and production
- Data loss prevention policies (
DLP): Control which connectors can be used together, preventing data exfiltration through unauthorized integrations - Capacity monitoring: Track storage, API request consumption, and AI Builder credits
"Governance is the make-or-break factor for enterprise Power Platform deployments. Organizations that roll out Power Platform without DLP policies, environment strategy, and Center of Excellence frameworks end up with thousands of unsupported automations and no visibility into what data is flowing where." -- Mikael Svenson, Microsoft MVP and author of the Power Platform Adoption Framework, from the Power Platform Community Summit 2023
Domain 3: Power BI Capabilities (15-20%)
Power BI Components
Power BI Desktop -- a free Windows application for creating reports and data models. Developers connect to data sources, apply transformations with Power Query, create DAX calculations, and build visualizations.
Power BI Service (app.powerbi.com) -- the cloud platform where reports and dashboards are published and shared. Premium features include scheduled refresh, workspaces, apps for distributing content, and paginated reports.
Power BI Report Server -- on-premises report hosting for organizations that cannot or will not host reports in the cloud. Requires Power BI Premium licensing.
Power BI Mobile -- iOS and Android apps for consuming Power BI reports and dashboards on mobile devices.
Key Power BI Concepts
Datasets are the data models that power reports. A single dataset can power multiple reports.
Reports contain visualizations (charts, tables, maps, KPI cards) organized into pages.
Dashboards are single-page collections of visuals (tiles) from one or more reports, pinned by the dashboard creator.
Workspaces are collaborative environments where teams create and share content. Workspace members with Editor roles can publish, edit, and delete content.
Power BI Apps are bundles of dashboards, reports, and datasets published to groups of users. They provide a read-only, organized view of content rather than direct workspace access.
| Visualization Type | Best For |
|---|---|
| Bar/Column chart | Comparing values across categories |
| Line chart | Trends over time |
| Scatter plot | Correlation between two measures |
| Map | Geographic data distribution |
| Treemap | Proportional part-to-whole relationships |
| Card | Single KPI value display |
DAX (Data Analysis Expressions) -- the formula language for creating calculated columns, measures, and tables in Power BI. The PL-900 tests awareness of DAX's purpose, not the ability to write DAX formulas.
Domain 4: Power Apps Capabilities (15-20%)
Types of Power Apps
Canvas apps are highly customizable applications built by dragging and dropping controls onto a canvas and connecting them to data sources. Canvas apps are designed pixel-by-pixel, enabling precise control over layout.
Model-driven apps are built on top of Dataverse data. They are configured through metadata -- defining forms, views, charts, and dashboards -- rather than custom layout. Model-driven apps are appropriate for complex business process applications that revolve around data management.
Power Pages (formerly Power Apps Portals) are external-facing websites connected to Dataverse data, enabling organizations to build customer-facing portals for case submission, self-service support, community forums, and partner portals.
Power Apps Studio
Canvas app development in Power Apps Studio uses:
- Screens: Pages of the app
- Controls: Text inputs, dropdowns, galleries, forms, buttons, images
- Formulas: Excel-like expressions that define control properties, handle navigation, and interact with data sources (
Navigate(),SubmitForm(),Filter()) - Data connections: Connected to Dataverse, SharePoint, SQL, and other sources through connectors
Power Fx -- the open-source formula language used across Power Platform (Power Apps, Power Automate desktop, Dataverse calculated columns). Based on Excel formula concepts, making it approachable for business users.
Domain 5: Power Automate Capabilities (15-20%)
Power Automate Flow Types
Cloud flows automate tasks across web services and cloud apps using connectors. Types:
- Automated flows: Triggered by events (a new row in SharePoint, an email with specific properties, a new record in Salesforce)
- Instant flows: Triggered manually by a user (button in a Power Apps app, mobile button)
- Scheduled flows: Run on a defined schedule (daily, weekly, hourly)
Desktop flows (formerly UI flows) automate tasks on Windows desktops and web browsers using robotic process automation (RPA) -- recording and replaying user interface interactions for applications without APIs or connectors.
Business process flows guide users through a defined series of stages and steps within a Model-driven app or Dynamics 365, ensuring consistent process execution.
Common Automation Scenarios
The PL-900 tests recognition of appropriate Power Automate solutions for business scenarios:
| Business Scenario | Appropriate Flow Type |
|---|---|
| Send approval email when a new expense is submitted | Automated (SharePoint/Dataverse trigger) |
| Copy a legacy desktop app's data to a database daily | Desktop flow (RPA) |
| Collect signatures in a document approval process | Automated with approval connector |
| Run a cleanup process every Sunday at midnight | Scheduled flow |
| Let a salesperson trigger a contract generation from their phone | Instant flow with Power Apps button |
AI Builder in Power Automate
AI Builder -- a Microsoft Power Platform feature that provides pre-built and custom AI models without requiring data science skills:
- Form processing: Extract data from structured documents (invoices, receipts, forms)
- Object detection: Identify products, inventory, or assets in images
- Sentiment analysis: Analyze text for positive, negative, or neutral sentiment
- Language detection: Identify the language of text
- Text recognition (OCR): Extract text from images and documents
The PL-900 tests awareness of AI Builder capabilities and which scenarios benefit from AI model integration.
Domain 6: Complementary Value (15-20%)
Power Platform and Microsoft 365
Power Platform integrates deeply with Microsoft 365:
- Microsoft Teams: Power Apps can be published as tabs in Teams channels; Power Automate flows can post adaptive cards to Teams
- SharePoint: Lists and document libraries are native data sources for Power Apps and Power Automate
- Outlook: Power Automate can process incoming emails, send automated responses, and route content to business processes
- Forms: Microsoft Forms data can trigger Power Automate flows for survey response processing
Power Platform and Azure
Organizations with sophisticated requirements extend Power Platform with Azure services:
- Azure Functions: Handle complex logic that exceeds Power Automate's capabilities
- Azure API Management: Expose internal APIs as custom connectors for Power Platform
- Azure Cognitive Services: Access AI capabilities beyond what AI Builder provides natively
- Azure Synapse Analytics: Serve as the data source for Power BI reports on large-scale datasets
Copilot in Power Platform
Microsoft has embedded Copilot AI capabilities throughout Power Platform:
- Power Apps Copilot: Describe an app in natural language and Copilot generates the initial data model and screens
- Power Automate Copilot: Describe a workflow in natural language and Copilot generates the flow
- Copilot Studio: Build AI-powered chatbots using natural language without writing code
- Power BI Copilot: Ask questions about data in natural language, receive AI-generated report visuals and summaries
Preparation Guide
The PL-900 is accessible to business users with no IT background. Microsoft Learn's free path covers all objectives in approximately 8-12 hours. Hands-on exploration through the Microsoft Power Platform free trial provides practical context for the conceptual content.
Tips for Non-Technical Candidates
- Focus on understanding what each component does and which business problems it solves
- Memorize the four main components and their primary use cases
- Understand when to use canvas apps versus model-driven apps
- Know the difference between automated, instant, and scheduled flows
- Understand Dataverse as the common data layer across Power Platform
Frequently Asked Questions
What is the PL-900 exam and who is it for?
The PL-900 exam tests foundational knowledge of Microsoft Power Platform -- the suite of low-code tools including Power BI for analytics, Power Apps for application development, Power Automate for workflow automation, and Copilot Studio for chatbots. It targets business users, citizen developers, functional consultants, and IT professionals who want to demonstrate awareness of what Power Platform can do before pursuing role-specific Power Platform certifications.
Is the PL-900 useful for someone who already uses Power BI?
The PL-900 provides context for how Power BI fits within the broader Power Platform ecosystem and the Dataverse data platform. Active Power BI users who already understand reports, datasets, and the Power BI service will find the Power BI domain straightforward and can focus study time on Power Apps, Power Automate, and Dataverse topics. The PL-300 (Power BI Data Analyst) is the appropriate certification for validating deep Power BI skills.
What certification comes after PL-900?
After PL-900, candidates choose a specialization based on their role: PL-300 (Power BI Data Analyst) for analytics, PL-400 (Power Platform Developer) for professional app development, PL-500 (Power Automate RPA Developer) for robotic process automation, or PL-200 (Power Platform Functional Consultant) for implementation consulting. Each targets a specific Power Platform role with deeper hands-on requirements.
References
- Microsoft. "Exam PL-900: Microsoft Power Platform Fundamentals." Microsoft Learn, 2024.
- Forrester Research. "The Total Economic Impact of Microsoft Power Platform." Commissioned by Microsoft, 2023.
- Microsoft. "Power Platform documentation." learn.microsoft.com/power-platform, 2024.
- Microsoft. "Microsoft Dataverse documentation." Microsoft Learn, 2024.
- Lamanna, Charles. "Power Platform keynote." Microsoft Business Applications Summit, 2023.
- Svenson, Mikael. "Power Platform Adoption Framework." Power Platform Community Summit, 2023.
- Microsoft. "Power BI documentation." learn.microsoft.com/power-bi, 2024.