PL-300 Study Plan: How to Prepare in 8 Weeks | MSPL300
MSPL300 ← All posts
Study plan

PL-300 Study Plan: How to Prepare in 8 Weeks

Published 19 September 2026 · Updated 14 October 2026

This PL-300 study plan shows you how to prepare for PL-300 in eight weeks with one to two hours a day. It is a week-by-week PL-300 study guide: what to learn, what to build in Power BI Desktop, when to start practice tests, and how to decide whether you are ready to book. It works for beginners and for people who already use Power BI at work.

Most candidates lose time deciding what to study next, not studying. This 8 week PL-300 plan removes that decision.

Who this 8 week PL-300 plan suits

The plan is built for working professionals, students and career switchers who can give an hour or two on most days. It fits you if:

  • You are looking at PL-300 for beginners and have little or no Power BI experience.
  • You use Excel or SQL and want a structured path into Power BI.
  • You already build reports but have never studied modelling, DAX or workspace security formally.

It is less suitable if you can only study at weekends. In that case use the 12-week version described later in this guide.

How long to study for PL-300

People often ask how long to study for PL-300. There is no official number, and anyone quoting one is guessing. Your background matters more than the calendar. A rough, unofficial way to think about it:

  • Regular Power BI user: four weeks of focused revision and practice may be enough.
  • Some Excel or SQL experience, new to Power BI: eight weeks is a sensible target.
  • Complete beginner with limited study time: plan for twelve weeks.

At one to two hours a day, eight weeks gives roughly 55 to 110 hours in total. Treat that as an estimate rather than a promise. What counts is the quality of those hours: building things in Power BI Desktop, not watching passively.

Before you start: set-up and exam basics

Do three things before day one.

  1. Install Power BI Desktop. It is a free download. Keep it open for the whole plan, because most exam questions describe a situation and ask what you would do.
  2. Read the official study guide once. Microsoft's PL-300 study guide lists the skills measured. The version this plan follows was updated on 20 April 2026, so older notes may describe an outdated outline.
  3. Learn the exam facts. The passing score is 700 or greater on a scale of 1 to 1000, which is a scaled score and not a percentage. You get 100 minutes. Our PL-300 exam format guide covers question types, case studies and retakes.

The exam measures four domains. The percentages below come from the Microsoft study guide:

  • Prepare the data: 25 to 30 percent
  • Model the data: 25 to 30 percent
  • Visualize and analyze the data: 25 to 30 percent
  • Manage and secure Power BI: 15 to 20 percent

The 8 week PL-300 plan at a glance

The table below summarises the whole plan. The sections after it explain each week in detail.

WeekFocusDomain / weightKey tasksCheckpoint
1Prepare the dataPrepare the data, 25–30%Microsoft Learn modules on getting, profiling, cleaning and loading data; clean a messy CSV in Power QueryCan you merge, append and unpivot without looking it up?
2Model the data, part 1Model the data, 25–30%Star schema, relationships, cardinality, cross-filter direction, date tableCan you explain why a relationship is one-to-many?
3Model the data, part 2 (DAX)Model the data, 25–30%Measures, CALCULATE, time intelligence, semi-additive measures, Performance AnalyzerCan you explain why a measure changes between two visuals?
4Visualize, analyze, manage and secureVisualize 25–30%; Manage 15–20%Report building, interactions, AI visuals; workspaces, roles, RLS, refreshBuild and publish a small report with RLS
5Practice tests, round 1All domainsTake practice tests one by one; log every wrong answerA written list of weak topics
6Practice tests, round 2 and gap reviewAll domainsMore tests; return to Learn for weak topics onlyRepeated errors are falling
7Practice Q&A and weak-topic revisionWeakest domainsOriginal practice questions with explanations; mark wrong ones and repeatSecond pass beats first pass
8Final revision and bookingAll domainsRevision video, free practice assessment, exam sandbox, book the examComfortable on a timed run

Weeks 1 to 4 build understanding; weeks 5 to 8 test it and close gaps. Keep those phases separate.

Daily time: what 1–2 hours looks like

A simple daily structure keeps sessions productive:

  • First 30 to 45 minutes: a Microsoft Learn module or the week's reading.
  • Next 30 to 60 minutes: hands-on work in Power BI Desktop applying what you just read.
  • Last 10 to 15 minutes: write down what you could not do and what confused you.

Weeks 1–4: PL-300 study guide by domain on Microsoft Learn

For the first four weeks, work through the official PL-300 learning path on Microsoft Learn, module by module, without skipping. It is free and it follows the exam outline, so it is the backbone of any PL-300 study guide. Use the exam's four domains as your weekly structure.

Week 1: Prepare the data

This domain covers connecting to data sources or a shared semantic model, data source settings including credentials and privacy levels, and choosing between DirectLake, DirectQuery and Import. It also covers profiling and cleaning (column statistics, null and unexpected values, import errors) and transforming and loading (data types, group and aggregate, pivot and unpivot, merge and append, reference versus duplicate queries).

What to practise in Power BI Desktop this week:

  • Connect to a CSV, an Excel file and one web or database source if you have access.
  • Turn on column quality, distribution and profiling, then find the errors and blanks.
  • Fix data types, split columns, unpivot a cross-tab and merge two queries.
  • Shape the data into one fact table and several dimension tables.

Week 2: Model the data, relationships and structure

Spend the first half of the modelling domain on design. Learn table and column properties, role-playing dimensions, cardinality, cross-filter direction and the common date table. Understand the difference between calculated columns and calculated tables, and when each is appropriate.

What to practise:

  • Build a star schema from the week 1 data and check every relationship in Model view.
  • Create a date table and mark it as a date table.
  • Change a cross-filter direction and note what changes in a visual.

Week 3: Model the data, DAX and optimisation

Week 3 is the hardest for most people, so protect your time. The study guide lists single-aggregation measures, CALCULATE, time intelligence, basic statistical functions, semi-additive measures, quick measures, calculated tables and columns, and calculation groups. It also covers optimisation: removing unnecessary rows and columns, using Performance Analyzer and DAX query view, and reducing granularity.

Practise by writing measures yourself first, then comparing them with quick measures. The DAX section below has worked examples. By the end of the week you should be able to explain filter context and row context in your own words.

Week 4: Visualize and analyze, then manage and secure

Week 4 covers two domains, so split it. Spend about four days on visualisation and analysis and three on managing and securing.

Visualize and analyze: choosing the right visual, formatting, themes, conditional formatting, slicers and filters, bookmarks, custom tooltips, visual interactions, drillthrough, sync slicers, the Selection pane, mobile layout, accessibility and when a paginated report is the better tool. Also look at the Analyze feature, grouping and binning, AI visuals, reference lines, forecasting and outliers. The outline includes some Copilot items, but most questions cover generally available features.

Manage and secure: creating and configuring workspaces, apps, publishing and updating items, subscriptions and data alerts, certifying content, when a gateway is required, and scheduled refresh. On the security side: workspace roles, item-level access, semantic model access, row-level security (RLS) roles, RLS group membership and sensitivity labels.

Build a small three-page report, publish it to a workspace if you can, and create two RLS roles. Many learners skip this domain because it is less fun. At 15 to 20 percent of the exam, that is a costly shortcut.

Note on tools: the PL-300 Preparation Bundle on this site gives you this same 8-week path as one roadmap image, a LINKS.txt file with every link in order, and an original practice Q&A PDF. Microsoft Learn and Power BI Desktop are free. The Udemy practice-test course used in weeks 5 and 6 is paid and is not included. See the bundle details. You can follow this plan entirely from the free resources listed in our free PL-300 resources guide.

Small DAX examples to practise

You do not need to memorise a huge function library. You do need to read a measure and predict what it returns. Rebuild these three on your own data until they feel routine. They assume a Sales table with an Amount column, a Date table, and a Product table.

CALCULATE changes filter context

Total Sales = SUM(Sales[Amount])

Online Sales =
CALCULATE(
    [Total Sales],
    Sales[Channel] = "Online"
)

CALCULATE takes an expression and applies new filters to it. Place Online Sales in a table next to Total Sales and compare them across product categories. Then add a slicer for channel and see what happens, because the explicit filter overrides the slicer for that column.

Time intelligence: year to date and same period last year

Sales YTD =
TOTALYTD([Total Sales], 'Date'[Date])

Sales SPLY =
CALCULATE(
    [Total Sales],
    SAMEPERIODLASTYEAR('Date'[Date])
)

YoY Growth % =
DIVIDE([Total Sales] - [Sales SPLY], [Sales SPLY])

These only work reliably with a proper date table: contiguous dates, a date-type column and a relationship to your fact table. If the numbers look wrong, check the date table first. This is a classic cause of unexpected results, in practice and in exam scenarios.

A semi-additive measure

Some values, such as stock levels or account balances, can be summed across products but not across time. Adding up daily stock for a month would be meaningless. A closing-balance pattern takes the last date in the current filter context:

Closing Stock =
CALCULATE(
    SUM(Inventory[Quantity]),
    LASTDATE('Date'[Date])
)

Put it in a matrix with months on rows. Each month should show the last day's stock, not a monthly total. If your data has gaps on the final day, research LASTNONBLANK as an alternative.

Weeks 5–6: practice tests and gap review

Now move from learning to testing. The aim is not a high score. It is a list of weak topics.

In the bundle roadmap these two weeks use a paid Udemy practice-test course, taking tests one by one. You can use any reputable practice-test source. Whatever you choose, follow the same method:

  1. Take one practice test at a time, ideally in one sitting.
  2. Review every wrong answer and also the right ones you guessed.
  3. Write each miss in your tracker (see the next section).
  4. Go back to Microsoft Learn for that topic only, then rebuild the feature in Power BI Desktop.
  5. Wait a few days and retake the weak areas.

If you miss the same type of question twice, do not take another test. Revise that topic properly first. Retaking tests until you remember the answers measures your memory of the test, not your skill.

Avoid exam dumps: they are against Microsoft's exam policies, can put your certification at risk of revocation, and are often wrong or outdated. Use original questions with explanations instead.

How to track weak areas

A tracker turns scattered mistakes into a revision plan. A spreadsheet is enough, with these columns:

ColumnWhat to write
DomainPrepare, Model, Visualize and analyze, or Manage and secure
TopicFor example RLS, cardinality, CALCULATE, merge queries
Why I missed itDid not know, misread, rushed, or guessed
Second attemptRight or wrong after a few days

After each practice test, count misses per domain. If one domain produces half your mistakes, that is where week 7 goes. If most misses are misreading rather than not knowing, practise slowing down on the last sentence of each question.

Week 7: practice Q&A and weak-topic revision

Week 7 combines practice questions with targeted revision. Work through a set of original practice questions with explanations. In the bundle roadmap this is the included practice Q&A PDF, which is made of original questions, not real exam questions. Mark the ones you get wrong and repeat them a few days later. Then revise only the topics from your tracker, rebuilding a small example of each from scratch in Power BI Desktop. Building a feature once teaches more than re-reading about it three times.

Week 8: final revision, practice assessment, sandbox and booking

Week 8 is about confidence and logistics.

  • Final revision: use a free video walkthrough of practice questions or a revision video for a last pass.
  • Free practice assessment: Microsoft offers one from the certification page. Take it timed, in one sitting, then review every answer.
  • Exam sandbox: try Microsoft's exam sandbox so the interface, question formats and navigation are familiar on the day.
  • Book the exam: price varies by country. It is about USD 165 in the United States and lower in India and many other countries. Always check the exact price on the Microsoft booking page.

Book when you are comfortably above the pass mark on timed practice, not when you merely hope to be. If you are not there, take one more week. Rescheduling costs far less than a retake. Retakes are paid, there is a 24-hour wait after a first failed attempt, and 14 days between later attempts, with a maximum of five attempts in 12 months.

PL-300 for beginners: extra advice if you have no Power BI experience

If you are following this plan as a complete beginner, a few adjustments help a great deal.

  • Add a week zero. Spend three or four days learning the Power BI Desktop interface, with its Report, Table and Model views and the Power Query editor, before starting week 1.
  • Learn data concepts first. Tables, rows, columns, keys, fact and dimension tables. Without them relationships will not make sense.
  • Build one project end to end. Import raw data, clean it, model it, write five measures and publish a report. A single full project connects the four domains.
  • Use the free resources. Our one-stop PL-300 preparation guide explains how the resources fit together.

If you need twelve weeks, that is fine.

Adapting the PL-300 study plan: 4-week fast track and 12-week slow track

The same structure compresses or stretches. Keep the order: learn, practise, fix gaps, then take the practice assessment and book.

TrackWho it suitsHow to arrange it
4-week fast trackDaily Power BI users, or people re-sitting after a lapseWeek 1: Prepare and Model (fast skim, deep on DAX). Week 2: Visualize and Manage and secure. Week 3: practice tests and tracker. Week 4: gap review, practice assessment, sandbox, book. Plan for two hours daily.
8-week standardMost working professionalsAs described above, one to two hours a day.
12-week slow trackBeginners, weekend-only learners, busy periods at workWeeks 1–2: Prepare. Weeks 3–5: Model, with a full week on DAX. Weeks 6–7: Visualize, Manage and secure. Weeks 8–9: practice tests. Week 10: gap review. Week 11: practice Q&A. Week 12: final revision and booking.

On the fast track, drop breadth in areas you already know, not hands-on practice. On the slow track, protect momentum: a short session beats skipping.

Common mistakes when you prepare for PL-300

  • Watching videos without building anything. Passive learning feels productive and feels the same as understanding. It is not.
  • Starting practice tests in week one. Without the concepts in place, tests become guesswork and discourage you.
  • Skipping Manage and secure. It is worth 15 to 20 percent. RLS, workspace roles and refresh questions are very learnable points.
  • Using dumps. They violate Microsoft policy and risk your certification.
  • Practising only single-answer questions. The exam can include multiple select, drag-and-drop, build list, hot area and case study formats.

How to know you are ready

  • You can build a report from a raw file to a published dashboard without looking up steps.
  • You can explain why a DAX measure returns different numbers in two contexts.
  • You can read a scenario once and identify what is being asked.
  • You finish timed practice with time to spare.
  • Your tracker shows few repeated errors in the last week.

No plan can guarantee a pass, and this one does not. It does make your progress visible, so you book with evidence rather than hope. For question types and timing, return to the exam format guide, and browse the full blog for more.

PL-300 study plan FAQ

How long to study for PL-300?

There is no official figure. At one to two hours a day, eight weeks is a reasonable target for someone new to Power BI, while experienced users may need about four weeks and complete beginners may prefer twelve. Judge readiness by practice results rather than the calendar.

Is this 8 week PL-300 plan enough for beginners?

Yes, if you add a few days to learn the Power BI Desktop interface and basic data concepts first, and you build things instead of only reading. If week 3 on DAX feels hard, extend the plan rather than rushing it.

How do I prepare for PL-300 with a full-time job?

Use short daily sessions of one hour on weekdays and a longer block at the weekend. Pair each reading session with a small hands-on task. If your schedule is tight, use the 12-week track and keep the same order of learning, practice and revision.

Do I need to pay for a PL-300 study guide or course?

No. Microsoft Learn, Power BI Desktop, the free Microsoft practice assessment and the exam sandbox are all free. Paid practice tests can help you find gaps, but they are optional. Our free resources guide lists what is available.

How many questions are on the exam and what is the pass mark?

Microsoft does not publish the number of questions. Candidates commonly report roughly 40 to 60 questions, including case studies, but that is unofficial. The passing score is 700 or greater on a scale of 1 to 1000, in 100 minutes.

When should I book the exam?

Book once you score comfortably above the pass mark on a timed Microsoft practice assessment and your tracker shows few repeated mistakes. Many candidates book during week 7 or 8 to create a firm deadline. Check the current price on the Microsoft booking page, since it varies by country.

What if I fail the exam?

You can retake it. You must wait 24 hours after a first failed attempt and 14 days between later attempts, with a maximum of five attempts in 12 months. Each retake is paid. Use your score report to rebuild your tracker and focus on the weakest domains.

Want this plan ready-made?

The PL-300 Preparation Bundle gives you the full 8-week roadmap, the study links in order and a practice Q&A PDF — one download, one-time payment. The Udemy practice-test course is bought separately.

Get the PL-300 Bundle