Free PL-300 resources worth your time (and what to skip)

Published 19 September 2026 · Updated 14 October 2026

There is no shortage of free PL-300 material. The problem is that most of it overlaps, some of it is outdated, and a little of it can put your certification at risk. This guide covers the best free PL-300 resources, exactly how to use each one, where each falls short, and when paying for something actually makes sense.

The short version: you can prepare for the Microsoft PL-300 exam (Power BI Data Analyst) with free official material alone. It takes discipline rather than money. If you want the exam details first, read our PL-300 exam format guide.

The free PL-300 resources at a glance

Here is how the main free options compare before we go through each in detail.

Time estimates are our own rough guides for someone new to Power BI, not Microsoft figures. Adjust them for your background.

PL-300 Microsoft Learn path: how to work through it

The official PL-300 Microsoft Learn path is the foundation. It is free, aligned to the skills measured, and maintained by Microsoft when the exam changes. If you only use one resource, use this one. You can find it from the official Power BI Data Analyst Associate certification page.

Work in order, not by interest

The modules build on each other: connecting and cleaning data comes before modelling, and modelling comes before DAX and visuals. Jumping straight to dashboards feels fun, but it leaves you unable to explain why a report shows the wrong numbers. Follow the sequence: prepare data, model data, visualize, analyze, then manage workspaces and security.

Do the labs, do not just read

Many modules include hands-on exercises. Skipping them is the single biggest mistake we see in self-study. Reading about a merge versus an append is not the same as doing one and watching the row count change. For each module, use this routine:

1. Read or watch the module once without taking notes.
2. Do the exercise in Power BI Desktop, following it step by step.
3. Repeat the key steps again from memory, with no instructions open.
4. Write three sentences in your own words: what it does, when you would use it, and what can go wrong.

That fourth step matters because scenario questions test judgement, such as which approach fits a requirement, not button locations.

The PL-300 practice assessment: use it as a diagnostic

The PL-300 practice assessment is a free set of questions published by Microsoft on Microsoft Learn. It is the closest free approximation of the official question style, which makes it valuable. It is also easy to waste.

Do not memorise it

The practice assessment contains a limited number of questions. If you retake it repeatedly until you score 100%, you have trained your memory, not your skills. The score then tells you nothing. Treat it as a measuring instrument, and avoid using it up early.

A diagnostic routine that works

1. Take it cold around the end of your learning path, timed and in one sitting, with no notes.
2. Sort every miss into one of four buckets: did not know, misread the question, knew it but second-guessed, or ran out of time.
3. Map each miss to a domain from the study guide: prepare, model, visualize and analyze, or manage and secure.
4. Fix the weakest domain first by returning to the relevant Learn module and redoing its lab.
5. Retake it a week or two later to check the gaps closed, then stop.

The mistake buckets matter. If most of your misses are “misread the question”, more content will not help; slower reading will. If most are “did not know”, go back to the labs.

The exam sandbox: remove interface surprises

Microsoft provides a free exam sandbox that lets you click through the exam interface and try the kinds of question formats you may see. PL-300 can include multiple choice, multiple select, drag-and-drop or ordering, build list, hot area or drop-down completion, and case studies. Some sections may not allow you to go back to earlier questions.

Spend 15 to 30 minutes in the sandbox once, ideally in the final two weeks. You are not testing Power BI knowledge. You are learning how a case study is laid out, how to move between tabs, and what happens when you cannot revisit a question. Seeing it once means less mental energy spent on the interface when the 100-minute clock is running. Candidates commonly report roughly 40–60 questions, including case studies, but this is unofficial because Microsoft does not publish the number. More detail is in our exam format article.

Microsoft Learn documentation for DAX and Power Query

The learning path teaches concepts. The documentation explains the details when something does not behave as you expected. Two areas deserve regular visits: the DAX function reference and the Power Query documentation (the M language and the transformation steps).

DAX: understand evaluation context

The model domain is 25–30% of the exam, and a large share of it is DAX: single aggregation measures, CALCULATE, time intelligence, basic statistical functions, semi-additive measures, quick measures and calculation groups. Memorising snippets will not carry you. Understanding filter context will.

Try this pattern against any sales model, and change one thing at a time to see what happens:

Total Sales = SUM ( Sales[SalesAmount] )

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

Sales Red Products =
CALCULATE ( [Total Sales], Product[Colour] = "Red" )

Then ask yourself: what changes if the Date table is missing? What if the Date column is not marked as the date table? What if a slicer already filters Product[Colour]? The documentation for CALCULATE and the time intelligence functions answers these questions precisely, and answering them is exactly the skill that scenario questions test.

Power Query: know the why behind each step

The prepare domain is also 25–30%. Practise these transformations until you can explain when to use each:

• Merge queries (a join across tables) versus append queries (stacking rows).
• Reference versus duplicate when you create a new query from an existing one.
• Pivot, unpivot and transpose, and why unpivoting is the usual fix for column-per-month data.
• Changing data types, and what happens when an import error appears because of a bad value.
• Splitting data into fact and dimension tables and choosing keys for relationships.
• Choosing between Import, DirectQuery and DirectLake for a given requirement.

When you read documentation, finish by doing the thing in Desktop. Reading alone gives a false sense of understanding.

Power BI Desktop and free sample datasets

Power BI Desktop is a free download from Microsoft, and it is the most underused of all the free PL-300 resources. You do not need a paid licence to practise data preparation, modelling and report building locally. Publishing, workspaces and sharing require a Power BI service account, so check what your own account allows when you reach the manage and secure topics.

Where to find data

Microsoft has published several well-known sample datasets over the years, including the Financial sample workbook and AdventureWorks-style retail and sales data. Search for these by name on Microsoft Learn or in the Power BI documentation. Public datasets from government open-data portals also work well, and they have a useful side effect: they are messy. Duplicate rows, text stored as numbers, blank values and inconsistent spellings give Power Query real work to do, which is closer to what the exam describes than a perfectly clean file.

Build a practice project that covers every domain

A single end-to-end project is the best way to join up everything in the study guide. Use this checklist and tick each item as you do it.

Prepare the data

• Connect to at least two sources, for example a workbook and a CSV file.
• Profile the data using column quality, distribution and profiling statistics. Find and fix nulls, duplicates and wrong data types.
• Create a parameter and use it in a query.
• Merge two queries, append two others, and unpivot one table.

Model the data

• Build a star schema with one fact table and several dimension tables.
• Create a proper date table and mark it as the date table.
• Set relationship cardinality and cross-filter direction deliberately, and write down why.
• Write at least five measures, including one with CALCULATE and one with time intelligence.
• Open Performance Analyzer and check which visual is slowest.

Visualize and analyze

• Build a three-page report with a consistent theme.
• Add conditional formatting, a custom tooltip page and a drillthrough page.
• Add bookmarks, sync a slicer across pages and use the Selection pane to layer objects.
• Try a forecast, a reference line, grouping or binning, and one AI visual.
• Set up a mobile layout and check accessibility settings such as alt text and tab order.

Manage and secure

• If your account allows it, publish to a workspace and note the workspace roles.
• Create a row-level security role with a DAX filter and test it using “View as”.
• Configure a scheduled refresh, and note when a gateway is required.

Row-level security is a topic you only understand once you test it. A simple role filter looks like this, and you should check it with “View as”:

[Region] = "West"

Videos and community forums: use them for one purpose

Microsoft's official Power BI YouTube channel is a reasonable free source for seeing a feature demonstrated, particularly new ones such as Copilot items that were added to the exam outline. Copilot topics are in the outline, but most exam questions cover generally available features, so do not let them take over your schedule.

Community walkthrough videos are useful for one specific thing: watching how a scenario question is read and broken down. Watching one good walkthrough after you have studied a topic is worth more than ten hours of video before you start. Use videos to confirm and fill gaps, not as your main method.

Official Microsoft community forums are valuable when your own project breaks. Searching an error message or describing what you tried often gets you unstuck, and explaining your problem clearly is itself good revision. Treat answers as suggestions to verify in Desktop, since quality varies.

Free vs paid: when does paying make sense?

To be direct: you can pass PL-300 with free resources. No paid product is required, and no one can promise you a pass. What paid material buys is mostly time and structure.

Paying can make sense when:

• You want more practice questions than the free practice assessment offers, so you can test a topic several times without memorising a small pool.
• You study alone and need the order decided for you, and you would rather not assemble links yourself.
• You have a firm exam date and limited time, so a ready sequence saves planning effort.
• You learn by drilling and reviewing explanations of wrong answers.

Paying does not make sense when you are buying instead of doing. A paid course you do not finish is worth less than the free path you do. If you pay for anything, pay for practice questions with explanations, not for another set of lectures covering the same ground as Microsoft Learn. Our one-stop PL-300 preparation guide compares the options in more detail.

A short mention of our own option: the PL-300 Preparation Bundle organises these free resources into an 8-week order, with the links in sequence and an original practice Q&A PDF. Its roadmap includes a Udemy practice-test course, which is paid, bought separately and not included in the bundle. You can follow the same order yourself using this article.

PL-300 dumps: why you should avoid them

You will see websites advertising “PL-300 dumps”, “real exam questions” or “actual exam answers”. They are not a shortcut. Here is why to avoid them.

• They breach Microsoft's exam policies. Dumps are leaked or copied exam content. Using or sharing it violates the rules you agree to when you book an exam.
• Your certification can be revoked. Candidates found to have used such material can have results cancelled and certifications revoked, and may be barred from future exams. That outcome is far worse than failing once.
• The answers are often outdated or wrong. Many dumps are recycled from older exams, including the retired DA-100, and nobody checks the answers. You may memorise something incorrect.
• You do not learn the skill. The point of the certification is that you can do the job. A question phrased differently from the one you memorised leaves you stuck, and so does a real analytics task at work.

For the same reason, treat any material that claims to contain real exam questions with suspicion, whether paid or free. Legitimate practice questions are original and describe themselves as such.

Other things to skip

• Anything written for DA-100. PL-300 replaced it, and older guides describe content that no longer matches.
• Collecting more resources instead of studying. Ten bookmarked courses feel like progress and produce none. Pick one path and finish it.
• Undated blog summaries. If a page does not say which version of the outline it covers, compare it with the official PL-300 study guide.

A free-only 6-week PL-300 study plan

This plan uses free resources only and assumes roughly 8 to 10 hours per week. If you have more time, our 8-week plan spreads the same material out.

Week 1: Prepare the data

Start the Microsoft Learn path. Cover connecting to data, profiling, cleaning and transformation. Do every lab. Begin your practice project by connecting to two sources and cleaning them.

Week 2: Model the data, part one

Study star schemas, relationships, cardinality and cross-filter direction, and the date table. Build the model for your project. Read the documentation on relationships when something looks wrong.

Week 3: DAX and optimisation

Focus on measures, CALCULATE, time intelligence and calculation groups. Write ten measures in your project. Use Performance Analyzer and learn what reduces model size, such as removing unused columns and lowering granularity.

Week 4: Visualize and analyze

Work through report design, formatting, bookmarks, drillthrough, tooltips, accessibility and the analysis features such as forecasting and outliers. Finish the report pages in your project.

Week 5: Manage and secure, then the diagnostic

Cover workspaces, apps, refresh, gateways, sharing and row-level security. At the end of the week, take the free practice assessment cold and sort your misses using the routine above.

Week 6: Fix gaps, sandbox, book

Spend the first half redoing labs for your weakest domain. Take 15 to 30 minutes in the exam sandbox. Retake the practice assessment near the end of the week. If your results and confidence both look steady, book the exam; if not, add another week without guilt. Check the current price on the Microsoft booking page, since it varies by country (about USD 165 in the United States, lower in many other countries).

Common mistakes when using free PL-300 resources

• Watching without building. Passive study gives a feeling of progress that disappears under exam pressure.
• Using the practice assessment too early. You waste the best free diagnostic.
• Ignoring the manage and secure domain. At 15–20%, it is the smallest domain, but still a meaningful share of the score. Many learners neglect it because it is hard to practise without a workspace.
• Memorising DAX. Learn evaluation context instead.
• Never reviewing wrong answers. Every wrong answer is a free lesson, so log each one.

Free PL-300 resources: frequently asked questions