PL-300

Power BI Data Analyst PL-300 practice exams

240 questions in 5 timed practice tests. Each test has about 50 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 4 exam domains.

Read the PL-300 study guide: what the exam covers, a 4-week plan and the topics people miss.

Exam at a glance

PL-300 practice exam settings
Practice tests 5
Questions in total 240
Questions per test About 50
Time limit per test 100 minutes
Pass mark 70%
Question types Single answer and multiple answer (22 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

PL-300 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Prepare the data 28% 67
Model the data 27% 64
Visualize and analyze the data 28% 67
Manage and secure Power BI 17% 42

Sample questions

Question 1 of 3

A Power BI Desktop file combines an Excel workbook containing customer names with a SQL Server database. When the query that filters SQL rows using values from the workbook refreshes, you receive a Formula.Firewall error stating the query references other queries or steps. Which change resolves the error while keeping data isolated appropriately?

  1. A Change the Excel source credentials from Windows to Anonymous so the workbook is treated as a public source
  2. B Disable the Allow data preview to download in the background option in the Current File data load settings page
  3. C Set compatible privacy levels, such as Organizational, on both sources or stage each source separately (correct answer)
  4. D Turn off Enable parallel loading of tables so that each query runs in sequence during the refresh
Why: The Formula.Firewall error is raised by the privacy-level engine when one source's data could be folded into another; assigning compatible privacy levels or splitting the access into separate queries removes the conflict. Background preview download only affects the editor experience. Changing credentials to Anonymous does not set a privacy level and would usually fail authentication. Parallel loading controls concurrency and has no effect on data-combination rules.

Question 2 of 3

A JSON response from a REST API loads into Power Query as a single column of Record values, and some fields contain nested lists of line items. You need one row per line item with the order fields repeated. Which sequence should you apply?

  1. A Convert the column to a list, then use Transpose and promote headers to turn records into columns
  2. B Use Parse > JSON on the record column, then pivot the line-items column using the order ID as values
  3. C Expand the records to columns, expand the line-items list to new rows, then expand the inner records (correct answer)
  4. D Use Extract Values on the line-items list with a comma delimiter, then split the column by delimiter into rows
Why: Records expand into columns and lists expand to new rows, so expanding the record, then the list, then the inner records yields one row per line item with order fields repeated. Parse JSON is for text that holds JSON, not values that are already records, and pivoting would aggregate rather than flatten. Transposing a list of records does not flatten nested lists. Extract Values concatenates list items as text, losing the structure of each line item.

Question 3 of 3

A report must show stock levels from an Azure SQL database that change every few seconds, and users expect values no older than one minute. The tables contain 500 million rows. Which approach is MOST appropriate?

  1. A Use Import mode for the stock table and configure eight scheduled refreshes in the service
  2. B Use Import mode for the stock table and refresh the semantic model on demand from Desktop
  3. C Use DirectQuery for the stock table and enable automatic page refresh on the report page (correct answer)
  4. D Use a live connection to the Azure SQL database and pin the page to a dashboard tile
Why: DirectQuery queries the source at view time and automatic page refresh can update visuals every minute, meeting the freshness need without importing 500 million rows. Eight scheduled refreshes give hours-old data and a very large import. On-demand refreshes from Desktop are manual and impractical. Live connections apply to Analysis Services and Power BI semantic models, not Azure SQL Database, and dashboard tiles do not change the data freshness.

What your score report looks like

Example attempt, PL-300 practice test 3

78%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Prepare the data 28%
88
Model the data 27%
81
Visualize and analyze the data 28%
76
Manage and secure Power BI 17%
58

Study next: Manage and secure Power BI. It is below the pass mark and carries 17% of the exam.

Domains and pass mark from our PL-300 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Prepare the data and Visualize and analyze the data, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the PL-300 practice exams

Are these real PL-300 exam questions?
No. We write every question ourselves and map it to the published PL-300 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. PL-300 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-100AB-100 Agentic AI Business Solutions Architect Microsoft Professional 250 100 $14.99
AB-730AI Business Professional AB-730 Microsoft Professional 250 100 $14.99
AZ-305Azure Solutions Architect AZ-305 Microsoft Professional 250 100 $14.99
SC-100Cybersecurity Architect SC-100 Microsoft Professional 250 120 $14.99
AZ-140Azure Virtual Desktop AZ-140 Microsoft Specialty 251 100 $14.99
DP-420Microsoft DP-420 Microsoft Specialty 250 100 $14.99