PL-300 Power BI Study Guide 2026: Pass the Data Analyst Exam

The PL-300 earns you the Microsoft Certified: Power BI Data Analyst Associate credential. It proves you can take raw data, clean it, model it, and turn it into reports and dashboards people actually use. Power BI is one of the most-requested analytics skills in the US job market, and the PL-300 is the specific line hiring managers put in job postings.

This guide covers what's on the exam, the topics that carry the most weight, and a focused 1-2 week plan to get you exam-ready.

What the PL-300 actually certifies

The PL-300 is a role-based Associate certification. It signals job-ready capability across the full Power BI workflow:

• Power Query — connect to sources and clean/transform data
• Data modeling — build relationships and write DAX
• Reports and dashboards — visualize and analyze data
• Publishing and security — manage workspaces and lock down access

It's aimed at data, BI, and reporting analysts; finance, ops, and marketing analysts who build dashboards; and Excel power-users moving into Power BI. There are no required prerequisites, though Microsoft recommends hands-on experience with Power Query, DAX, and the Power BI service before you sit.

One note on naming: PL-300 replaced the old DA-100 exam. It is current and is not being retired — so ignore any DA-100 study material you stumble across.

Exam structure

• ~40-60 questions, mixed formats: multiple choice, drag-and-drop, case studies, and interactive/lab items
• ~100 minutes to complete
• Passing score: 700 on a scale of 1-1000 (this is a scaled score, not a raw percentage)
• Cost: ~$165 USD
• No prerequisites required to register

The lab/interactive items are what set this exam apart from a pure multiple-choice test — you may be asked to actually perform a task in a Power BI-like environment, not just recognize the right answer. Reading about Power BI isn't enough; you need hands-on reps.

2026 update: The skills were refreshed in April 2026 to add Microsoft Copilot (Copilot-assisted report creation) and Microsoft Fabric content, including the DirectLake storage mode. Make sure whatever you study reflects the current version.

The four domains and their weights

The exam is built from four skill areas. Here's how they break down:

The first three domains are nearly even, so you can't afford to skip any of them. Here's what lives inside each.

1. Prepare the data (25-30%)

• Connect to data sources
• Choose the right connectivity: Import, DirectQuery, or DirectLake
• Profile, clean, and transform data with Power Query
• Structure data into fact and dimension tables

2. Model the data (25-30%)

• Build relationships and set cardinality
• Write DAX measures, including CALCULATE and time intelligence
• Use calculation groups
• Optimize with Performance Analyzer

3. Visualize and analyze the data (25-30%)

• Choose and format the right visuals
• Add bookmarks, drillthrough, and tooltips
• Use AI visuals and forecasting
• Build reports with Copilot assistance

4. Manage and secure Power BI (15-20%)

• Configure workspaces, apps, gateways, and scheduled refresh
• Set workspace roles
• Apply row-level security (RLS) and sensitivity labels

The highest-yield topics

If you're short on time, over-invest here. These are the concepts the PL-300 tests again and again.

DAX and CALCULATE

CALCULATE is the single most-tested function on the exam. It's the function that changes filter context, and everything else in DAX orbits it. Know:

• Filter context and how CALCULATE modifies it
• Time intelligence: TOTALYTD, SAMEPERIODLASTYEAR, DATEADD
• The difference between measures, calculated columns, and calculated tables

The gotcha: a calculated column is computed at data refresh and works in row context; a measure is computed at query time and works in filter context. Expect a question that hinges on that distinction.

Star schema data modeling

The exam wants you to model like a professional, which means a star schema:

• Fact tables hold the numbers and events; dimension tables hold the descriptive who/what/when/where
• Relationship cardinality: 1:many vs many:many
• Cross-filter direction: single vs both
• A dedicated date table for time intelligence to work

The gotcha: setting cross-filter direction to "Both" can create ambiguity and performance problems. Single-direction is the safe default; "Both" is the answer only when the scenario specifically calls for it.

Power Query (M)

• Merge vs append (combine columns vs stack rows)
• Reference vs duplicate queries
• Pivot vs unpivot
• Query folding and why it matters for performance

Row-Level Security (RLS)

• Static vs dynamic RLS
• Dynamic RLS uses USERNAME() or USERPRINCIPALNAME() to filter by the logged-in user

The gotcha: RLS is applied at the model level, not the visual level. It restricts the data itself, so a question asking where security lives has one right answer.

Storage modes

• Import — fast copy held in memory
• DirectQuery — live queries against the source, but slower
• DirectLake — the Fabric mode that aims for the best of both

The gotcha: DirectQuery does not support every DAX function. If a scenario needs full DAX flexibility, Import is usually the answer.

Memory aids

• "CALCULATE = change the context." That's the whole function in four words.
• Star schema: facts = numbers/events, dimensions = who/what/when/where.
• Storage modes: Import = fast copy in memory, DirectQuery = live but slower, DirectLake = Fabric best-of-both.

A 1-2 week study plan

This assumes you already work with data and can put in focused hours. Stretch it out if Power BI is new to you.

Days 1-2: Prepare the data

Get comfortable in Power Query. Connect to a couple of sources. Practice merge vs append, reference vs duplicate, pivot vs unpivot. Understand when query folding happens. Learn the trade-offs between Import, DirectQuery, and DirectLake.

Days 3-5: Model the data

This is the heaviest section — spend real time here. Build a star schema with fact and dimension tables. Set relationships and cardinality. Add a date table. Then drill DAX: write measures, master CALCULATE, and practice time intelligence functions. Nail the measure-vs-calculated-column distinction until it's automatic.

Days 6-8: Visualize and analyze

Build reports. Practice choosing and formatting visuals. Add bookmarks, drillthrough, and tooltips. Try forecasting and the AI visuals. Experiment with Copilot-assisted report creation so it's familiar if it appears.

Days 9-10: Manage and secure

Create a workspace, publish a report, and set up an app. Configure a gateway and scheduled refresh. Assign workspace roles. Set up both static and dynamic RLS, and apply sensitivity labels.

Days 11-14: Practice and review

Run full practice sets under timed conditions. The lab/interactive items reward hands-on fluency, so keep a real Power BI file open and rebuild anything you get wrong. Review missed questions until the reasoning is reflexive, not memorized.

Wondering whether this timeline is realistic for you? Read our honest breakdown of how hard the PL-300 exam is.

Frequently asked questions

How much does the PL-300 cost in 2026?

Around $165 USD.

What's the passing score?

700 on a 1-1000 scale. It's a scaled score, so don't treat 700 as "70% of questions correct."

How many questions are on the PL-300?

Roughly 40-60 questions in about 100 minutes, mixing multiple choice, drag-and-drop, case studies, and interactive lab items.

Do I need prerequisites?

No prerequisites are required. Microsoft recommends hands-on experience with Power Query, DAX, and the Power BI service, but you can register without any other cert.

Does the PL-300 expire?

The Associate certification is valid for 12 months, and you renew it free through an online assessment on Microsoft Learn before it lapses.

Is the PL-300 the same as DA-100?

The PL-300 replaced the retired DA-100. It's the current exam and is not being retired — always study current material.

---

Practice like it's exam day. Run free PL-300 questions on the Power BI Data Analyst exam page — no card, no email-trap, built to mirror the real formats.