Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free PL-300 Power BI Data Analyst Practice Questions

Pass your Microsoft Certified: Power BI Data Analyst Associate (Exam PL-300) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Two tables have a one-to-many relationship. Which side holds the unique key values?

A
B
C
D
to track
Same family resources

Explore More Microsoft Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Microsoft Power BI Data Analyst

Practice QuestionsStudy GuideCheat SheetFlashcards3 videos4 blogs

Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)

Practice QuestionsStudy GuideCheat SheetFlashcards1 video2 blogs

Azure MD-102

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Microsoft Certified: Security Operations Analyst Associate (SC-200)

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Azure MS-102

Practice QuestionsCheat Sheet2 videos3 blogs

Microsoft Power Platform Functional Consultant

Practice Questions2 blogs

More From This Family

Videos and articles for deeper review.

VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)ArticleFREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)27 min readArticleFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)24 min readArticleFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)24 min readArticleFREE PL-400 Power Platform Developer Exam Guide 2026: Pass First Try16 min read
2026 Statistics

Key Facts: PL-300 Power BI Data Analyst Exam

$165

Exam Fee (USD)

Microsoft / Pearson VUE

100 min

Working Time

Microsoft

700/1000

Passing Score

Microsoft

40-60

Questions

Microsoft / Pearson VUE

4 areas

Skill Areas Measured

PL-300 study guide

1 year

Credential Validity

Microsoft certification renewal

As of the April 20, 2026 skills-measured update, Microsoft lists PL-300 as an associate-level exam costing $165 USD, with roughly 40-60 questions, a 100-minute working time, and a passing score of 700 on a 1000-point scale delivered through Pearson VUE. The four skill areas are Prepare the data (25-30%), Model the data (25-30%), Visualize and analyze the data (25-30%), and Manage and secure Power BI (15-20%). The credential is valid for one year and renews free online through Microsoft Learn.

Sample PL-300 Power BI Data Analyst Practice Questions

Try these sample questions to test your PL-300 Power BI Data Analyst exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1In Power BI Desktop, which tool do you use to connect to, transform, and load data before it reaches the data model?
A.Power Query Editor
B.DAX query view
C.Performance Analyzer
D.The Selection pane
Explanation: Power Query Editor (powered by the M language) is the ETL layer where you connect to sources, apply transformation steps, and shape data before it loads into the model. DAX query view runs DAX, Performance Analyzer measures rendering, and the Selection pane manages visual layering.
2Which storage mode keeps a compressed copy of the data inside the Power BI model for the fastest query performance?
A.Import
B.DirectQuery
C.DirectLake
D.Live connection
Explanation: Import mode loads and compresses data into the in-memory VertiPaq engine, giving the fastest query performance and full DAX and Power Query support. DirectQuery and DirectLake query the source rather than storing a full copy, and Live connection points to an external semantic model.
3You need to connect a report to a very large, frequently changing source without importing all rows. Which storage mode is most appropriate?
A.Import
B.DirectQuery
C.Composite with all tables imported
D.A blank query
Explanation: DirectQuery leaves data at the source and sends queries when visuals render, which suits very large or rapidly changing data that cannot be fully imported. Import would require loading and refreshing all rows, and an all-imported composite model is just Import.
4Where in Power BI Desktop do you change a data source's credentials and privacy level after the query has been created?
A.Data source settings
B.The Modeling tab
C.Format pane
D.Bookmarks pane
Explanation: Data source settings (from the Transform data menu or File and Options) is where you edit credentials, privacy levels, and connection details for existing sources. The Modeling tab manages model objects, the Format pane styles visuals, and Bookmarks save report states.
5What is the primary purpose of creating a parameter in Power Query?
A.To store a reusable value, such as a server name or file path, that can be changed in one place
B.To create a DAX measure that responds to slicers
C.To define row-level security filters
D.To schedule dataset refresh in the service
Explanation: Power Query parameters store reusable values like server names, folder paths, or filter values so you can change them in one place and reuse them across queries. They are commonly used to switch between development and production sources.
6In the Power Query Editor, which feature shows the percentage of valid, error, and empty values in each column?
A.Column quality
B.Column distribution
C.Column profile
D.Query dependencies
Explanation: Column quality displays the share of valid, error, and empty values for a column, helping you spot data issues quickly. Column distribution shows distinct and unique counts, and Column profile gives detailed statistics for the sampled rows.
7By default, the column profiling statistics in Power Query are based on which rows?
A.The top 1,000 rows
B.The entire data set
C.A random 10 percent sample
D.Only rows containing errors
Explanation: By default Power Query profiles based on the top 1,000 rows to stay responsive. You can switch the status-bar setting to base column profiling on the entire data set when you need accurate statistics across all rows.
8A column of dates imported as text causes incorrect sorting and breaks time intelligence. What is the best fix in Power Query?
A.Change the column data type to Date
B.Hide the column in report view
C.Sort the table alphabetically
D.Add a calculated column in DAX to display the text
Explanation: Setting the correct Date data type in Power Query ensures dates sort chronologically and that time intelligence and the date hierarchy work. Choosing data types early is a Prepare the data best practice. Hiding or re-displaying the text does not fix the underlying type.
9You import data where months are spread across columns (Jan, Feb, Mar). Which Power Query operation turns those header values into rows to build a proper fact table?
A.Unpivot columns
B.Pivot columns
C.Transpose
D.Group by
Explanation: Unpivot columns converts wide data, where values are spread across many columns, into a narrow attribute-value format that is ideal for a fact table. Pivot does the reverse, Transpose swaps rows and columns, and Group by aggregates rows.
10You want a second query that always reflects the latest steps of an existing query without copying the steps. Which option should you choose?
A.Reference
B.Duplicate
C.Append
D.Merge
Explanation: Reference creates a new query that points to the output of the existing query, so changes to the source query flow through automatically. Duplicate copies all the steps independently, while Append and Merge combine data from multiple queries.

About the PL-300 Power BI Data Analyst Exam

Microsoft's PL-300 exam earns the Power BI Data Analyst Associate certification for professionals who prepare, model, visualize, and secure data with Power BI. The blueprint centers on Power Query and the M language for data preparation, star-schema modeling and DAX for analytics, report design and AI-assisted analysis, and Power BI Service governance including workspaces, refresh, and row-level security.

Questions

50 scored questions

Time Limit

100 minutes

Passing Score

700/1000

Exam Fee

$165 (Microsoft)

PL-300 Power BI Data Analyst Exam Content Outline

25-30%

Prepare the data

Connect to data sources and shared semantic models, choose between Import, DirectQuery, and DirectLake, create parameters, profile and clean data, and transform and load data with Power Query and the M language.

25-30%

Model the data

Build star-schema fact and dimension tables, set relationship cardinality and cross-filter direction, create a common date table, author DAX measures with CALCULATE and time intelligence, and optimize performance with Performance Analyzer.

25-30%

Visualize and analyze the data

Select and format visuals, apply conditional formatting and filters, build bookmarks, drillthrough, and custom tooltips, design for accessibility and mobile, and analyze patterns with forecasting, clustering, AI visuals, and Copilot.

15-20%

Manage and secure Power BI

Create workspaces and apps, configure scheduled refresh and gateways, promote or certify content, assign workspace roles and item-level access, and implement row-level security and sensitivity labels.

How to Pass the PL-300 Power BI Data Analyst Exam

What You Need to Know

  • Passing score: 700/1000
  • Exam length: 50 questions
  • Time limit: 100 minutes
  • Exam fee: $165

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

PL-300 Power BI Data Analyst Study Tips from Top Performers

1Split study time roughly evenly across Prepare the data, Model the data, and Visualize and analyze the data, since each carries 25-30% of the exam.
2Practice Power Query transforms hands-on: merge versus append, reference versus duplicate queries, pivot/unpivot, and choosing column data types early in the query.
3Master the difference between calculated columns (row context, stored, computed at refresh) and measures (filter context, computed at query time) before exam day.
4Drill CALCULATE and time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD against a marked date table, because they appear frequently.
5Know the storage-mode tradeoffs: Import for speed, DirectQuery for large or real-time sources, and DirectLake for Fabric lakehouse data.
6Be able to configure row-level security: define roles with DAX filters, test with View as, and map users through security groups in the Power BI Service.

Frequently Asked Questions

What are the current official exam facts for PL-300?

Microsoft lists PL-300 as an associate exam that costs $165 USD, runs about 100 minutes, and requires a score of 700 or greater on a 1000-point scale to pass. The exam is delivered through Pearson VUE either at a test center or via online proctoring and typically contains 40 to 60 items.

What skills are weighted most heavily on PL-300?

Three of the four skill areas carry equal top weight: Prepare the data (25-30%), Model the data (25-30%), and Visualize and analyze the data (25-30%). Manage and secure Power BI is the smallest area at 15-20%, so most study time should go to Power Query, DAX modeling, and report building.

Do I need to know DAX and Power Query for PL-300?

Yes. Microsoft states candidates should be proficient with both Power Query and Data Analysis Expressions (DAX). Power Query and the M language drive the Prepare the data area, while DAX measures, CALCULATE, and time intelligence are central to the Model the data area.

Is PL-300 still current in 2026?

Yes. Microsoft last updated the PL-300 skills-measured objectives on April 20, 2026, and the exam remains the active path to the Power BI Data Analyst Associate certification. The update added Copilot-assisted report and analysis tasks and DirectLake storage mode.

How long is the PL-300 certification valid?

Microsoft associate certifications expire one year after you earn them. You can renew for free by passing a short online assessment on Microsoft Learn within six months before the expiration date.

What is the best way to prepare for PL-300?

Start with Microsoft's free learning paths and the free practice assessment, build a small star-schema model with real data, and drill mixed DAX and Power Query questions until they feel routine. Because three areas share the top weight, balance study time across data preparation, modeling, and visualization.