PL-300 — Microsoft Power BI Data Analyst
Microsoft

Microsoft Power BI Data Analyst (PL-300) Practice Questions

★★★★★★ 4.2 90 verified reviews
116 questions
June 15, 2026 updated
✓ Online quiz simulator

Sample Questions (12 of 116 shown)

Q1 Prepare the Data (25–30%)
You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use?
  1. Show whitespace
  2. Column distribution
  3. Column profile
  4. Column quality
  5. Monospaced
✓ Correct Answer: A, D
Column distribution shows value counts and distinct counts for each column. Column quality shows the percentage of valid, empty, and error values. Together they help identify uniqueness.
Q2 Prepare the Data (25–30%)
You have a Power BI Desktop report named Report1 that uses an Azure SQL database as a data source. User1 plans to create a report using the same data source. You need to simplify the connection for User1. Which file type should you create?
  1. PBIDS
  2. PBIT
  3. XLSX
  4. PBIX
✓ Correct Answer: A
A PBIDS file (Power BI Desktop data source file) contains only connection information. Users can open it to connect to the data source without knowing the connection details.
Q3 Prepare the Data (25–30%)
You import a sales table and notice product names have inconsistent casing and trailing spaces. What should you do first?
  1. Create a calculated column to trim the text
  2. Clean the column in Power Query
  3. Change the data type to text
  4. Use a DAX measure to standardize
✓ Correct Answer: B
Cleaning and standardizing text in Power Query during the data preparation phase avoids duplicate categories and creates a cleaner semantic model.
Q4 Prepare the Data (25–30%)
The finance team wants to load the latest CSV file from a folder each week without changing the report. What is the best approach?
  1. Manually replace the file each week
  2. Connect to the folder in Power Query
  3. Use a parameter to point to the file
  4. Import all files and filter
✓ Correct Answer: B
Folder-based data import in Power Query is more scalable than manually replacing individual files. It automatically processes all files in the folder.
Q5 Prepare the Data (25–30%)
A column contains text-typed order dates in mixed regional formats. What is the safest fix?
  1. Use locale-aware type conversion in Power Query
  2. Change the data type to date
  3. Use a DAX function to parse dates
  4. Split the column into parts
✓ Correct Answer: A
Mixed regional date formats can break default date conversion. Locale-aware type conversion in Power Query handles different regional formats correctly.
Q6 Prepare the Data (25–30%)
You need to remove rows where ALL fields are empty. Where should you perform this?
  1. In Power Query before loading
  2. In the data model using DAX
  3. In a calculated column
  4. In the visual filter pane
✓ Correct Answer: A
Removing blank rows in Power Query during data preparation reduces model size and improves refresh efficiency.
Q8 Prepare the Data (25–30%)
A sales column contains currency symbols and commas. What should be done before modeling?
  1. Clean and convert to numeric type in Power Query
  2. Keep the column as text
  3. Use a DAX measure to extract the values
  4. Split the column into multiple parts
✓ Correct Answer: A
Measures can only work correctly with amounts stored as numbers. Cleaning and converting to a numeric type in Power Query is essential before modeling.
Q9 Prepare the Data (25–30%)
You connect to a database table with 50 columns but only need 12. What is the best practice?
  1. Import all columns and hide the unnecessary ones
  2. Remove unnecessary columns during data preparation
  3. Create a view in the database
  4. Use a calculated table to select columns
✓ Correct Answer: B
Narrower tables improve both refresh speed and model efficiency. Removing unnecessary columns in Power Query is the best practice.
Q10 Prepare the Data (25–30%)
You need to combine "Orders" and "Returns" tables from different files with the same structure. Which transformation applies?
  1. Merge queries
  2. Append queries
  3. Group rows
  4. Pivot columns
✓ Correct Answer: B
Append queries stacks rows from two or more tables with similar columns. Merge queries join related tables side by side.
Q11 Prepare the Data (25–30%)
You need to enrich a "Sales" table with "Region" names from a lookup table. Which transformation applies?
  1. Append queries
  2. Merge queries
  3. Group by
  4. Unpivot columns
✓ Correct Answer: B
Merge queries bring in related columns from another table, similar to JOIN in SQL.
Q12 Prepare the Data (25–30%)
Your query has many unnecessary applied steps affecting refresh performance. What should you review?
  1. Query folding and step optimization
  2. The data source credentials
  3. The model relationships
  4. The visual performance analyzer
✓ Correct Answer: A
Efficient Power Query transformations push work back to the data source (query folding) and avoid unnecessary steps, speeding up refreshes.
Q13 Prepare the Data (25–30%)
A date column has blanks representing unknown delivery dates rather than missing records. What should you avoid?
  1. Automatically removing those rows
  2. Creating a calculated column
  3. Filtering in the visual
  4. Replacing blanks with a default date
✓ Correct Answer: A
Blanks may have business meaning and require explicit handling rather than automatic removal.

You've viewed 3 of 116 questions. Start the free practice exam to answer all questions with instant feedback.

Exam overview

The PL-300 exam, officially titled "Microsoft Power BI Data Analyst," is the sole exam required to earn the Microsoft Certified: Power BI Data Analyst Associate certification. The exam validates your ability to transform raw data into actionable insights—covering Power Query data preparation, semantic model design with DAX calculations, report visualization and storytelling, and secure Power BI Service administration. Delivered through Pearson VUE with native Microsoft Learn documentation access, the exam uses unreviewable case study blocks, drag-and-drop sequencing, and build-list ordering questions to test both conceptual knowledge and hands-on decision-making in a timed environment.

Candidates pursuing this Associate-level credential typically have hands-on experience transforming data via Power Query, writing intermediate-level DAX calculations, and managing enterprise assets within the Power BI Service environment. Microsoft does not require any mandatory prerequisite exams, though a strong understanding of data repositories and data processing both on-premises and in the cloud is expected. The most effective preparation path combines the official Course PL-300T00-A (or its self-paced Microsoft Learn equivalent), hands-on semantic model building in a free Power BI developer account, and timed runs in the Exam Sandbox to build speed navigating the split-screen Microsoft Learn interface under pressure.

Mastering four weighted domains is required to pass. "Prepare the data" (25–30%) tests your ability to connect to data sources, select appropriate storage modes (DirectLake, DirectQuery, Import), create and modify parameters, evaluate data quality issues, and apply Power Query transformations including merging and appending queries while maintaining star schema designs. "Model the data" (25–30%) focuses on table and column property configuration, relationship cardinality and cross-filter direction design, role-playing dimensions, date table creation, DAX measure writing with the CALCULATE function, calculation groups, and model performance optimization using Performance Analyzer and DAX query view. "Visualize and analyze the data" (25–30%) covers visual selection and formatting, Copilot-assisted report page and narrative visual creation, bookmark and page navigation design, conditional formatting, and AI visual implementation including Key Influencers and Decomposition Tree. "Manage and secure Power BI" (15–20%) requires you to create and manage workspaces, assign workspace roles, configure item-level access and semantic model permissions, implement Row-Level Security (RLS) roles, and apply sensitivity labels.

Our PL-300 practice materials mirror the exam's domain weighting and question formats, with particular attention to the scenarios that most frequently trip up candidates: understanding exactly how the DAX CALCULATE function overwrites or merges with active page filters, determining correct relationship cross-filter directions (bi-directional versus single) without causing ambiguous paths, and interpreting Performance Analyzer results to identify poorly performing measures. Each online practice question includes a detailed answer explanation that walks through the reasoning and references the relevant Power BI Desktop or Service configuration path, while the downloadable PDF packages the same question bank for offline review during commutes or in environments without stable internet.

Ready to test your Power BI data analysis skills? Start the free PL-300 practice test now and identify whether your preparation is strongest in data preparation, semantic modeling, visualization, or Power BI Service administration before exam day.

Official Exam Domains & Weighting

To successfully pass the PL-300 exam, candidates must master the following core domains:
  • Domain1: Prepare the data (25–30%)
Covers data source connection and credential management, storage mode selection (DirectLake, DirectQuery, Import), parameter creation and modification, data profiling and quality evaluation, null and inconsistent value resolution, and Power Query transformations including data type selection, column transformations, merging and appending queries, and star schema design implementation.
  • Domain2: Model the data (25–30%)
Focuses on table and column property configuration, role-playing dimension implementation, relationship cardinality and cross-filter direction design, common date table creation, calculated column versus calculated table use cases, DAX single aggregation measures, the CALCULATE function and filter context evaluation, calculation groups, semi-additive measures, and model performance optimization using Performance Analyzer and DAX query view.
  • Domain3: Visualize and analyze the data (25–30%)
Tests visual selection and formatting, Copilot deployment for report page and narrative visual creation, customized theme application, conditional formatting and slicing, page navigation and bookmark design, tooltip tuning, mobile view layout optimization, grouping and binning implementation, AI visuals (Key Influencers, Decomposition Tree), reference lines and forecasting, and Copilot-assisted semantic model summarization.
  • Domain4: Manage and secure Power BI (15–20%)
Covers workspace creation and item deployment, workspace role assignment, item-level access and semantic model permission configuration, Row-Level Security (RLS) role and group membership implementation, and sensitivity label application for data governance.

What Our Customers Say 90 verified reviews

4.2 ★★★★★★ Based on 90 reviews
★★★★★★
The PL-300 explanations are where this really stands out. Not just which answer is right but WHY the others are wrong.
— Aria H.
★★★★★★
Detailed, organized, and accurate. Exactly what you want in PL-300 prep material. The explanations deserve special mention.
— Gabriel L.
★★★★★★
Lifetime access was the selling point for me. Got sidetracked for a few months and came back — everything was still there for PL-300.
— Layla S.
★★★★★★
I scored 890 on the PL-300 exam. Went through about 80% of this question bank and it was more than enough to pass.
— Levi C.
★★★★★★
I was struggling with PL-300 until I found this. The domain-based organization and instant feedback helped me identify weak areas quickly.
— David L.
★★★★★★
I was really impressed by the depth of the PL-300 answer explanations. Feels like having a tutor walk you through each question.
— Jack W.

Log in to rate this exam and leave a review.

Submitted for moderation before publishing. Keep it helpful and respectful.

Frequently Asked Questions

The most common pitfalls involve DAX filter context evaluation—specifically understanding exactly how the CALCULATE function overwrites or merges with active page filters—and optimizing relationship configurations. Candidates frequently confuse the correct application of bi-directional cross-filtering versus single cross-filtering, leading to performance degradation or incorrect data aggregations on multi-part exam scenarios. Our practice questions include scenario-based items on both topics, with detailed explanations that walk through the DAX filter context evaluation step by step.

Treat the exam as if it were closed-book. The 120-minute limit does not allow sufficient time to search for fundamental concepts. Use your study path to master Power Query transformations and DAX syntax, utilizing the built-in Microsoft Learn interface strictly to verify specific function parameters or obscure feature properties under pressure. Practice navigating documentation quickly using the official Microsoft Exam Sandbox before your test day. Our practice questions are designed to be answered without external reference, building the recall speed you need on exam day.

Do not rely on unverified third-party sources. Utilize the official, free Microsoft Learn Practice Assessments directly on the PL-300 exam page to receive an analytical score report with structural rationales for every question. Additionally, review the Exam Readiness Zone on Microsoft Learn for video deep-dives into high-weight exam topics. Combining these official resources with our supplementary practice question bank gives you both the authoritative content and the repetition needed to build exam-day confidence.

The certification is valid for one year from the date you pass the exam. You can renew it for free during a 6-month eligibility window prior to expiration by completing a self-paced, unproctored online renewal assessment on Microsoft Learn. If you miss this window, the certification expires completely, and you must retake the live proctored PL-300 exam. No additional exam fee is required for renewal if completed within the eligibility window.

If you do not pass on your first attempt, you must wait at least 24 hours before rescheduling a second try. For attempts 3 through 5, a 14-day waiting period is strictly enforced between each registration, and you are capped at five total attempts per rolling 12-month period. Our practice tests help you identify domain-specific knowledge gaps before using an attempt, particularly in the heavily weighted "Model the data" and "Visualize and analyze the data" domains where DAX calculation and relationship configuration scenarios require both speed and accuracy.

The online mock exam replicates the PL-300 exam format with unreviewable case study sections, drag-and-drop sequencing, build-list ordering questions, and multiple-response questions that award partial credit for individually correct selections. The practice engine also simulates the split-screen Microsoft Learn workflow and includes performance-based scenarios that test whether you can quickly locate the correct DAX function syntax or Power Query transformation step without losing time—the same skill the real exam measures.

Yes, the full question bank is available as a downloadable PDF that packages all practice questions, answer explanations, and domain references in a portable format. The PDF gives special attention to DAX CALCULATE function filter context evaluation, calculation group implementation, Row-Level Security (RLS) role configuration, and Performance Analyzer optimization workflows—topics that together account for up to 50% of the exam's weighted content. It is ideal for offline review during commutes, flights, or in environments without stable internet access.