PL-900 Free Study Guide: Power Platform Fundamentals
Free study guide for the Microsoft PL-900 Power Platform Fundamentals certification exam — topics, resources, and preparation tips.
Exam Overview
The PL-900: Microsoft Power Platform Fundamentals exam validates your foundational understanding of the Power Platform. It is the entry-level certification — no prior hands-on experience is required, although it certainly helps.
| Detail | Value |
|---|---|
| Exam code | PL-900 |
| Number of questions | 40-60 questions |
| Question types | Multiple choice, drag-and-drop, case studies, yes/no sets |
| Duration | 65 minutes |
| Passing score | 700 out of 1,000 |
| Cost | $165 USD (prices vary by country, check Microsoft Learn for local pricing) |
| Certification earned | Microsoft Certified: Power Platform Fundamentals |
| Renewal | Annual renewal via a free online assessment on Microsoft Learn |
| Languages | English, Japanese, Chinese, Korean, French, German, Spanish, Portuguese, Arabic, and more |
Who Should Take This Exam
- Business professionals exploring the Power Platform for the first time
- IT administrators who need to understand what the Power Platform does before managing it
- Students or career changers entering the Microsoft ecosystem
- Anyone wanting to validate foundational knowledge before pursuing PL-200, PL-400, or PL-600
This is not a deeply technical exam. You do not need to write Power Fx formulas, build complex flows, or configure Dataverse security. You need to understand what each component does, when to use it, and how they work together.
Skill Domains and Weightings
The exam covers these domains. The percentages indicate how much of the exam focuses on each area.
| Domain | Weight | Focus |
|---|---|---|
| Describe the business value of the Power Platform | 20-25% | ROI, use cases, ecosystem overview |
| Identify foundational components of the Power Platform | 10-15% | Dataverse, connectors, environments, AI Builder |
| Demonstrate the capabilities of Power Apps | 20-25% | Canvas vs Model-driven, app types, design |
| Demonstrate the capabilities of Power Automate | 20-25% | Cloud flows, desktop flows, process mining |
| Describe the capabilities of Power BI | 10-15% | Reports, dashboards, data sources |
| Describe the capabilities of Microsoft Copilot Studio | 5-10% | Chatbots, topics, entities |
Domain-by-Domain Study Guide
Domain 1: Describe the Business Value of the Power Platform (20-25%)
This domain tests whether you understand why the Power Platform exists and what business problems it solves.
Key concepts to know:
- Low-code/no-code: What it means, who benefits, how it differs from traditional development
- Citizen developer: Definition, role in the organisation, relationship with IT
- Centre of Excellence (CoE): What it is, why organisations need one, the CoE Starter Kit
- Business value: Cost reduction, speed to market, digital transformation, process automation
- Power Platform ecosystem: How Power Apps, Power Automate, Power BI, Copilot Studio, and AI Builder work together
- Microsoft 365 integration: How the Power Platform extends Teams, SharePoint, Outlook, and Excel
- Dynamics 365 relationship: Power Platform as the foundation for Dynamics 365 apps
- Connectors: What they are, standard vs premium, custom connectors
- Environments: What they are, why they exist, default vs production vs sandbox
- Dataverse: What it is, why it matters, how it differs from a SharePoint list or SQL database
- Security and governance: DLP policies, admin centre, tenant-level controls
- AI Builder: What it does, common AI models, how it integrates with apps and flows
Study tip: This domain is conceptual. Focus on understanding the “why” and “when” rather than the “how”. Microsoft Learn modules cover this well.
Domain 2: Identify Foundational Components (10-15%)
Key concepts to know:
- Dataverse: Tables, columns, relationships, environments, solutions, security roles
- Connectors: Standard (included with M365), Premium (require additional licence), Custom (built from APIs)
- Environments: Types (default, production, sandbox, developer), purpose, creating and managing
- Power Platform Admin Centre: What administrators can do — manage environments, DLP policies, analytics, capacity
- Solutions: What they are, managed vs unmanaged, how they support ALM (Application Lifecycle Management)
- AI Builder: Pre-built models (document processing, object detection, text recognition, prediction) vs custom models
Study tip: Know the differences between environment types and when to use each. Understand what Dataverse provides that SharePoint Lists do not.
Domain 3: Demonstrate the Capabilities of Power Apps (20-25%)
Key concepts to know:
- Canvas apps: Blank canvas, pixel-level control, any data source, mobile-friendly design
- Model-driven apps: Data-first, auto-generated from Dataverse tables, built-in dashboards and views
- When to use which: Canvas for custom UX and non-Dataverse sources, Model-driven for complex data models on Dataverse
- Power Apps portals / Power Pages: External-facing websites built on Dataverse (know it exists and what it does)
- Formulas and Power Fx: Basic understanding of what Power Fx is and where it is used (you do not need to write complex formulas)
- Controls: Galleries, forms, buttons, text inputs, media controls
- Data sources: How apps connect to data — connections, connectors, delegation basics
- Sharing: How to share apps, what permissions are needed, per-user vs shared connections
- Mobile: Power Apps mobile app, phone vs tablet layout
Study tip: If you have never opened Power Apps, spend an hour building a simple Canvas app from a SharePoint list. The visual experience helps enormously with remembering concepts.
Domain 4: Demonstrate the Capabilities of Power Automate (20-25%)
Key concepts to know:
- Cloud flows: Automated (trigger-based), Instant (button/manual), Scheduled (time-based)
- Triggers and actions: What they are, how they chain together
- Templates: Pre-built flow templates for common scenarios
- Approvals: Built-in approval workflow — create, assign, respond, track
- Desktop flows (Power Automate Desktop): What RPA is, attended vs unattended, when to use desktop flows
- Process mining: What it is, how it analyses business processes, task mining vs process mining
- AI in flows: AI Builder actions in flows (document processing, text analysis)
- Connectors in flows: Same connector model as Power Apps — standard, premium, custom
- Error handling: Basic concept of run-after configuration, retry policies
- Process Advisor: Analyse and optimise processes before automating
Study tip: Understand the three types of cloud flows (automated, instant, scheduled) and when to use each. Know the difference between cloud flows and desktop flows.
Domain 5: Describe the Capabilities of Power BI (10-15%)
Key concepts to know:
- Power BI Desktop: Free authoring tool for building reports
- Power BI Service: Cloud service for publishing, sharing, and collaborating on reports
- Reports vs Dashboards: Reports contain pages of visualisations; Dashboards pin tiles from multiple reports
- Data sources: Excel, SQL, SharePoint, Dataverse, hundreds of others
- Visualisations: Bar charts, line charts, pie charts, maps, tables, KPIs, slicers
- DAX: Data Analysis Expressions — know what it is (you do not need to write it)
- Power Query: Data transformation tool — know what it does (clean, shape, merge data)
- Workspaces: Where reports and datasets live in the Power BI Service
- Sharing: Share reports, publish to web, embed in Teams/SharePoint, row-level security basics
- Dataflows: Reusable data preparation logic
- Paginated reports: Pixel-perfect, printable reports (like SSRS) — know they exist
Study tip: Open Power BI Desktop (it is free) and connect to a sample dataset. Build one simple report. Seeing the interface once makes the exam questions much easier.
Domain 6: Describe the Capabilities of Microsoft Copilot Studio (5-10%)
Key concepts to know:
- What it is: A low-code tool for building AI-powered chatbots (formerly Power Virtual Agents)
- Topics: Conversation paths — trigger phrases, nodes, branching logic
- Entities: Data extraction from user messages — pre-built (date, number, email) and custom
- Channels: Where bots can be deployed — Teams, websites, Facebook, custom channels
- Generative AI: Copilot Studio can use generative AI to answer questions from your content (websites, documents)
- Integration: Bots can call Power Automate flows for backend actions (book a meeting, look up data, create a record)
- Authentication: Bots can authenticate users for personalised experiences
- Analytics: Built-in analytics to track bot performance, resolution rates, escalation rates
Study tip: Copilot Studio is a smaller portion of the exam, but do not skip it. Know the basic concepts and how bots integrate with the rest of the Power Platform.
Free Study Resources
Microsoft Learn (Primary Resource)
Microsoft provides a free, comprehensive learning path specifically for PL-900:
- Learning path: “Microsoft Power Platform Fundamentals” on Microsoft Learn
- Duration: Approximately 8-10 hours of content
- Includes: Interactive modules, knowledge checks, sandbox exercises
- Practice assessment: Free practice questions on Microsoft Learn (search “PL-900 practice assessment”)
This should be your primary study resource. It is written by Microsoft, aligned to the exam objectives, and completely free.
Additional Free Resources
- Microsoft Power Platform documentation: Official docs for each component
- Power Platform Community: Forums with real-world questions and answers
- Microsoft Power Platform YouTube channel: Product demos and feature overviews
- Power Platform Admin Centre documentation: For governance and admin topics
- Microsoft 365 Developer Programme: Free developer tenant for hands-on practice (includes Power Apps, Power Automate, and more)
Study Plan: Two-Week Schedule
If you are starting from scratch, here is a realistic study plan:
Week 1: Learn the Concepts
| Day | Focus | Time |
|---|---|---|
| Day 1 | Power Platform overview, business value, ecosystem | 2 hours |
| Day 2 | Dataverse fundamentals, environments, connectors | 2 hours |
| Day 3 | Power Apps — Canvas and Model-driven | 2 hours |
| Day 4 | Power Apps — hands-on: build a simple Canvas app | 2 hours |
| Day 5 | Power Automate — cloud flows, triggers, actions | 2 hours |
| Day 6 | Power Automate — desktop flows, process mining, approvals | 1.5 hours |
| Day 7 | Rest or review weak areas | — |
Week 2: Reinforce and Practice
| Day | Focus | Time |
|---|---|---|
| Day 8 | Power BI — reports, dashboards, data sources | 2 hours |
| Day 9 | Copilot Studio — topics, entities, channels | 1.5 hours |
| Day 10 | AI Builder, governance, DLP, admin centre | 1.5 hours |
| Day 11 | Practice assessment on Microsoft Learn (first attempt) | 1.5 hours |
| Day 12 | Review incorrect answers, revisit weak areas | 2 hours |
| Day 13 | Practice assessment (second attempt) + review | 1.5 hours |
| Day 14 | Light review of key concepts, rest before exam | 1 hour |
Total study time: Approximately 20-22 hours.
Exam Tips
Before the Exam
- Take the free practice assessment on Microsoft Learn at least twice. It is the closest thing to the real exam format.
- Do not memorise — understand. The exam tests comprehension, not recall. If you understand why Canvas apps differ from Model-driven apps, you can answer any question about it.
- Get hands-on, even briefly. Thirty minutes building a Canvas app teaches you more than two hours of reading about Canvas apps.
- Know the terminology. The exam uses specific Microsoft terms: “environment”, “solution”, “managed solution”, “connector”, “delegation”, “DLP policy”. Make sure you know what each means.
During the Exam
- Read the entire question before looking at answers. Exam questions often have qualifiers like “most appropriate” or “which two” that change the correct answer.
- Eliminate wrong answers first. On questions where you are unsure, ruling out obviously wrong options improves your odds significantly.
- Watch for “best” vs “correct”. Some questions have multiple technically correct answers but ask for the best or most appropriate one. Think about Microsoft’s recommended practices.
- Flag and return. If a question is taking too long, flag it and move on. You can return to flagged questions at the end.
- Time management. With 40-60 questions in 65 minutes, you have roughly 1-1.5 minutes per question. Do not spend 5 minutes on one question.
Common Exam Traps
- Canvas vs Model-driven: Questions will describe a scenario and ask which app type is more appropriate. Remember: Canvas = custom UI + any data source; Model-driven = Dataverse + auto-generated UI.
- Standard vs Premium connectors: SharePoint, Office 365, and Excel are standard (included with M365). Dataverse, SQL Server, and HTTP are premium.
- Cloud flows vs Desktop flows: Cloud flows automate cloud services (APIs). Desktop flows automate desktop applications (RPA). Process mining analyses existing processes.
- Power BI Desktop vs Power BI Service: Desktop is the free authoring tool. Service is the cloud platform for sharing and collaboration.
- Environments: Default environment is for personal productivity. Production environments are for business apps. Sandbox environments are for testing.
After the Exam
If you pass (and with proper preparation, you will), your certification appears in your Microsoft Learn profile and on Credly (digital badge). The certification is valid for one year and can be renewed for free via an online assessment on Microsoft Learn.
If you do not pass, you can retake the exam after 24 hours. You receive a score breakdown by domain, so you know exactly which areas to strengthen.
Next Steps After PL-900
| Certification | Focus | Recommended For |
|---|---|---|
| PL-200 | Power Platform Functional Consultant | People who build solutions on the platform |
| PL-400 | Power Platform Developer | Pro developers using code-first approaches |
| PL-600 | Power Platform Solution Architect | Senior practitioners designing enterprise solutions |
| PL-500 | Power Automate RPA Developer | Specialists in desktop automation |
| DA-100 / DP-600 | Data Analyst / Fabric Analytics Engineer | Power BI specialists |
PL-900 is the foundation. It proves you understand the platform. The role-based certifications (PL-200, PL-400, PL-600) prove you can use it professionally. If you are pursuing a Power Platform career, PL-200 is the natural next step.