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.
- 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.
- 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.
- 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.
| Week | Focus | Domain / weight | Key tasks | Checkpoint |
|---|---|---|---|---|
| 1 | Prepare the data | Prepare the data, 25–30% | Microsoft Learn modules on getting, profiling, cleaning and loading data; clean a messy CSV in Power Query | Can you merge, append and unpivot without looking it up? |
| 2 | Model the data, part 1 | Model the data, 25–30% | Star schema, relationships, cardinality, cross-filter direction, date table | Can you explain why a relationship is one-to-many? |
| 3 | Model the data, part 2 (DAX) | Model the data, 25–30% | Measures, CALCULATE, time intelligence, semi-additive measures, Performance Analyzer | Can you explain why a measure changes between two visuals? |
| 4 | Visualize, analyze, manage and secure | Visualize 25–30%; Manage 15–20% | Report building, interactions, AI visuals; workspaces, roles, RLS, refresh | Build and publish a small report with RLS |
| 5 | Practice tests, round 1 | All domains | Take practice tests one by one; log every wrong answer | A written list of weak topics |
| 6 | Practice tests, round 2 and gap review | All domains | More tests; return to Learn for weak topics only | Repeated errors are falling |
| 7 | Practice Q&A and weak-topic revision | Weakest domains | Original practice questions with explanations; mark wrong ones and repeat | Second pass beats first pass |
| 8 | Final revision and booking | All domains | Revision video, free practice assessment, exam sandbox, book the exam | Comfortable 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:
- Take one practice test at a time, ideally in one sitting.
- Review every wrong answer and also the right ones you guessed.
- Write each miss in your tracker (see the next section).
- Go back to Microsoft Learn for that topic only, then rebuild the feature in Power BI Desktop.
- 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:
| Column | What to write |
|---|---|
| Domain | Prepare, Model, Visualize and analyze, or Manage and secure |
| Topic | For example RLS, cardinality, CALCULATE, merge queries |
| Why I missed it | Did not know, misread, rushed, or guessed |
| Second attempt | Right 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.
| Track | Who it suits | How to arrange it |
|---|---|---|
| 4-week fast track | Daily Power BI users, or people re-sitting after a lapse | Week 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 standard | Most working professionals | As described above, one to two hours a day. |
| 12-week slow track | Beginners, weekend-only learners, busy periods at work | Weeks 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