Power BI Certification (PL-300): Exam, Renewal and Study Plan for Canadians

data analysis microsoft certification power bi certification Nov 11, 2026
Power BI certification (PL-300) guide: 100-minute exam, pass mark 700, free yearly renewal and free learning paths

By Stephen Adindu, Lead Coach at The Career Accelerators. Last updated November 2026.

The Microsoft Power BI certification is called Microsoft Certified: Power BI Data Analyst Associate, and you earn it by passing one exam, PL-300. The exam lasts 100 minutes, you need a scaled score of 700 out of 1,000 to pass, and you can take it online or at a test centre. Microsoft sets the price by the country where you sit the exam, so check the Canadian price when you book. The certification lasts a year, and you renew it for free with a short online assessment.

Below: what the exam tests, booking, retakes, renewal, free training, an eight-week plan, and what the certificate does for your job search.

Key takeaways
  • No formal prerequisites, but Microsoft expects you to be proficient with Power Query and DAX.
  • Preparing, modelling, and visualizing data each carry 25 to 30% of the exam; managing and securing Power BI carries 15 to 20% (skills measured as of 20 April 2026).
  • Renewal is free, online and open book, in the six months before your certification expires.
  • Microsoft's five PL-300 learning paths, its practice assessment and Power BI Desktop are all free.
  • The certificate supports a job application; it doesn't replace SQL, a portfolio or project experience.

What is the Power BI certification (PL-300)?

PL-300 is the exam code. The credential you get when you pass is Microsoft Certified: Power BI Data Analyst Associate. Microsoft rates it at the intermediate level and aims it at data analysts who turn raw data into reports that business users can understand and explore on their own.

It shows you can take data from its source to a published, secured report. When we checked on 28 October 2026, PL-300 was current, with no retirement notice.

PL-300 at a glance Details
Exam length 100 minutes (Microsoft lists 120 minutes of seat time for associate exams of this length)
Passing score 700 or higher on a scale of 1 to 1,000 (a scaled score)
Price in Canada Set by the country where the exam is proctored. Check it when you book.
Languages English, French, Spanish, German, Italian, Japanese, Korean, Portuguese (Brazil), Chinese (Simplified) and Chinese (Traditional)
Where Through Pearson VUE: online with a remote proctor, or at a test centre

What does the PL-300 exam cover?

Microsoft's PL-300 study guide lists the skills measured as of 20 April 2026. That update made only minor changes, to three subsections: connecting to data, making reports easier to use, and managing workspaces. When Microsoft next updates the exam, English changes first and other languages follow about eight weeks later.

Skill area Share of the exam
Prepare the data 25 to 30%
 
Model the data 25 to 30%
 
Visualize and analyze the data 25 to 30%
 
Manage and secure Power BI 15 to 20%
 

Bars show the top of each range. Source: Microsoft Learn, PL-300 study guide (skills measured as of 20 April 2026).

In plain terms:

  • Prepare the data. Connect to sources, choose Import, DirectQuery or DirectLake, then profile, clean and shape data in Power Query into fact and dimension tables.
  • Model the data. Set relationships, add a date table, write DAX (CALCULATE, time intelligence, calculation groups) and tune performance with Performance Analyzer and DAX query view.
  • Visualize and analyze the data. Build reports with bookmarks, drillthrough, mobile layouts and accessibility settings, use AI visuals, forecasting and outlier detection, and use Copilot to create report pages.
  • Manage and secure Power BI. Set up workspaces, apps, sharing and scheduled refresh, know when you need a gateway, and apply row-level security and sensitivity labels.

Microsoft says its bullets illustrate each skill rather than limit it, and commonly used preview features can appear, so study each whole area.

How long is the PL-300 exam, and what are the questions like?

You get 100 minutes. Microsoft says most of its exams have 40 to 60 questions, and its formats include multiple choice, drag and drop, build list, hot area, active screen and case studies, with labs on some role-based exams. The PL-300 page warns that you may have interactive components. Three rules to know:

  • Microsoft Learn is open. On associate exams you can look things up on learn.microsoft.com, but the timer keeps running. Use it for the odd detail only.
  • Partial credit counts. On most multi-part questions you earn a point for each part you get right, and wrong answers cost nothing, so answer every question.
  • Some questions aren't scored. You won't know which ones, so treat them all as real.

What is the PL-300 passing score?

You need 700 or more on a scale of 1 to 1,000. It's a scaled score, so it doesn't necessarily mean you got 70% of the points: Microsoft sets the pass mark from the skills the exam requires and how hard the questions are. For most exams, the result comes within minutes of finishing, and your score appears in your Microsoft Learn profile within 24 hours.

How much does the Power BI certification cost in Canada?

Microsoft doesn't publish one worldwide price: the PL-300 page says it depends on the country or region where the exam is proctored. To find the Canadian price, sign in to Microsoft Learn, choose to schedule the exam from the PL-300 page, and check the amount Pearson VUE quotes for an exam taken in Canada before you pay.

Item Cost Notes
PL-300 exam Set by country Check the Canadian price during booking
Student pricing Academic price Offered in most countries (India and China excluded). Verify your student status in your Learn profile first.
Retake Paid again Each new attempt is a new booking
Power BI Desktop Free Windows app, from the Microsoft Store or Download Center

Can you take PL-300 online or at a test centre?

Both, booked through Pearson VUE from the exam page. Online, a proctor watches you through your webcam and microphone, in a walled room with a closed door that nobody else enters. Run the system test on the same computer and in the same place you'll use on the day, check in from 30 minutes before your slot, and bring government ID whose name matches your Microsoft profile exactly. If you don't want facial comparison or recording, book a test centre.

If the exam isn't offered in your native language, you can request an extra 30 minutes through the English as a Second Language form on Microsoft's accommodations page. Other accommodations, such as assistive devices, are usually approved before you book.

How do you get the Power BI certification, step by step?

1. Set up your Microsoft Learn profile
Use a personal Microsoft account and your name as it appears on your ID.
2. Work through the free learning paths
Build along in Power BI Desktop as you go.
3. Take the free practice assessment
Let your score decide what to study next.
4. Book PL-300 through Pearson VUE
Online or at a test centre. Check the price before you pay.
5. Pass with 700 or more
Your score appears in your Microsoft Learn profile within 24 hours.
6. Renew every year for free
Pass the online assessment before it expires.

What is the PL-300 retake policy?

Every attempt is a separate paid booking, and you're capped at five attempts at the same exam in the 12 months after your first try. The wait grows after your first retake: one day after your first fail, then two weeks before each attempt after that. A pass is final, too: you can only sit PL-300 again once the certification has expired.

How do you renew the Power BI certification?

Associate certifications expire after one year. To keep yours, pass a free renewal assessment on Microsoft Learn:

  • When: it opens six months before your expiry date, and Microsoft emails you if you've agreed to its communications.
  • How: it's online, short, unproctored and open book.
  • Attempts: there's no limit. If you fail, you can try again straight away, and after your second try you wait at least 24 hours between attempts.
  • Result: a pass extends your certification by one year from its current expiry date.

If it lapses, you have to pass PL-300 again.

What free Microsoft training prepares you for PL-300?

Microsoft Learn training is free, and you need a profile only to track your progress. The syllabus for Microsoft's three-day instructor-led course, PL-300T00, lists five self-paced learning paths you can work through on your own:

Free learning path Modules Exam area it supports
Get started with Microsoft data analytics 4 Background, including Fabric and Copilot in Power BI
Prepare data for analysis with Power BI 3 Prepare the data
Model data with Power BI 6 Model the data (DAX)
Design effective reports in Power BI 4 Visualize and analyze the data
Manage and secure Power BI 5 Manage and secure Power BI

The certification page also links the free PL-300 practice assessment, an exam sandbox for trying the exam screens, and Exam Readiness Zone prep videos. Microsoft says its practice questions aren't the same as the real exam, so use them to find gaps, not to memorize answers.

One catch: the "manage and secure" skills live in the Power BI service, which needs a work or school email (not Gmail or Hotmail). Without one, Microsoft suggests starting a Microsoft 365 trial, which creates one. A free Fabric licence gives you My workspace; sharing needs a trial or Pro licence.

How much Power BI experience do you need before PL-300?

Microsoft sets no minimum hours or months. It expects proficiency with Power Query and DAX, and its modelling path assumes you know Power BI Desktop and basics such as tables and relationships. You're probably ready when you can do all of these without a tutorial:

  • Load data from Excel, CSV files and a database, then fix data types, nulls and errors in Power Query.
  • Build a star schema with a date table and the right relationships.
  • Write measures with CALCULATE, plus a year-to-date and a prior-year comparison.
  • Build a report page with slicers, bookmarks and drillthrough that a manager could use without help.
  • Publish to a workspace, schedule a refresh and set up row-level security.

New to Power BI? Build a few simple reports from public datasets first.

A realistic PL-300 study plan

This is the plan we suggest for someone who already uses Excel and has tried Power BI, at about six to eight hours a week. It isn't a Microsoft requirement: allow more time if DAX is new to you, less if you use Power BI at work.

Week Focus
1 Install Power BI Desktop, finish "Get started with Microsoft data analytics", and take the practice assessment once to get a baseline score.
2 and 3 "Prepare data for analysis with Power BI". Clean and reshape a messy public dataset in Power Query from start to finish.
4 and 5 "Model data with Power BI". Build a star schema and write measures every day: CALCULATE, time intelligence and semi-additive measures.
6 "Design effective reports in Power BI". Add bookmarks, drillthrough, tooltips, a mobile layout and accessibility settings to your report.
7 "Manage and secure Power BI". Publish to a workspace, build an app, schedule a refresh and test row-level security.
8 Retake the practice assessment, try the exam sandbox, revise your weakest area against the study guide, then book the exam.

Keep the report you build. It covers all four skill areas and gives employers something to see.

Does the Power BI certification help you get hired in Canada?

It helps, but it won't get you hired on its own. Job Bank says the data analyst occupation isn't regulated in Canada and that it has no information on certification requirements. Employers usually ask for a bachelor's degree or college program, often in computer science, computer engineering or mathematics, plus programming and related experience. So PL-300 is a supporting signal, not a ticket in.

It proves you can use Power BI to Microsoft's standard, which can help when you don't yet have Canadian work experience to point to. It doesn't prove SQL or delivery for real stakeholders, so pair it with a portfolio report, solid SQL and project experience you can discuss in interviews.

Job Bank doesn't publish pay for a tool or a certificate. A close match for Power BI analyst work is Job Bank's Data Analyst - Informatics and Systems line, in the database analysts and data administrators group (NOC 21223). Job Bank files "Business Intelligence Analyst - Information Technology (IT)" under a different group, business systems specialists (NOC 21221). The figures below are converted at 37.5 hours a week for 52 weeks.

Data Analyst - Informatics and Systems (NOC 21223) Hourly About a year
Canada, median C$40.87 C$79,700
Canada, low C$25.00 C$48,750
Canada, high C$61.03 C$119,000

Source: Job Bank, wages updated 19 November 2025. Low and high are roughly the 10th and 90th percentiles across all workers; they don't track years of experience, so they aren't entry-level and senior pay.

For the wider path into the role, see our guide on how to become a data analyst.

PL-300 and TCA's data analyst course

Our data analyst course is delivered live online: four days of foundational training plus a 12-week live project where you work as a data analyst on real-world datasets. The program covers SQL, Power BI, Excel, Python, Tableau and ETL on Microsoft Azure, and it includes preparation for the Microsoft Certified: Power BI Data Analyst Associate (exam PL-300). You also get one-on-one mentorship from senior data analysts, a resume review, interview preparation, and references based on your live project work. No prior IT experience is required.

Power BI certification FAQs

Is the PL-300 exam hard?
Microsoft rates it intermediate and expects you to be proficient with Power Query and DAX, so it's tough if you've only watched videos and haven't built anything. The free practice assessment is the best way to judge where you stand before you pay.

Can I take a break during the exam?
Yes, but the exam clock keeps running while you're away, and you can't go back to any question you saw before the break, even one you marked for review. Finish and review what you've seen first.

Which Microsoft account should I book with?
A personal one. Microsoft strongly recommends it, because exam records tied to a work or school account are lost if you leave that organization.

Can I prepare on a Mac?
Power BI Desktop is a Windows application, so to practise in Desktop on a Mac you'll need access to a Windows computer or a Windows environment.

Stephen's tip: Do at least one practice run in exam conditions: 100 minutes, no notes, and Microsoft Learn only for quick lookups. Note every topic you had to look up and learn it properly, because on exam day each lookup costs clock time.

Ready to get Power BI certified?

Our data analyst course teaches Power BI alongside SQL, Excel and Python, prepares you for PL-300, and gives you a 12-week live project to talk about in interviews. Not sure whether you're ready for the exam? Book a free call and we'll help you plan your next step.

Related reading: how to become a data analyst in Canada and the best data analytics bootcamps and courses for Canadians.

Sources