All Practice Exams

316+ Free PL-300 Practice Questions

Prepare for the Microsoft Power BI Data Analyst Associate (PL-300) exam with instant access — no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
~65-75% Pass Rate
316+ Questions
100% Free
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.

2026 Statistics

Key Facts: PL-300 Exam

~65-75%

Estimated Pass Rate

Industry estimate

700/1000

Passing Score

70%

40-60 hrs

Study Time

Recommended

100 min

Exam Duration

40-60 questions

$165

Exam Fee

Microsoft

1 year

Certification Valid

Annual renewal available

The Microsoft Power BI Data Analyst Associate (PL-300) requires a passing score of 700 out of 1000 (70%). The exam has 40-60 questions to be completed in 100 minutes. All four domains are weighted approximately equally (25-30% each for the first three, 15-20% for security/management). The estimated pass rate is 65-75% for well-prepared candidates. This certification demonstrates proficiency in Power BI and data analysis, with no prerequisites required.

Sample PL-300 Practice Questions

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

1You need to connect to a SQL Server database that requires Windows Authentication from Power BI Desktop. What is the recommended approach?
A.Use the SQL Server connector with Database authentication and enter Windows credentials
B.Use the SQL Server connector and select "Windows" authentication method
C.Install the SQL Server ODBC driver and use the ODBC connector
D.Export the SQL Server data to Excel first, then import from Excel
Explanation: Power BI Desktop supports Windows Authentication natively through the SQL Server connector. When connecting, you simply select "Windows" as the authentication method. This uses your current Windows credentials to authenticate with SQL Server, eliminating the need to enter separate credentials and ensuring secure, integrated authentication.
2In Power Query, you have a column containing mixed date formats (e.g., "01/15/2024", "2024-01-15", "15-Jan-2024"). Which transformation should you use to standardize all values to a consistent date format?
A.Split Column by Delimiter, then reassemble the parts
B.Replace Values to rewrite each format variant
C.Change Type with Locale
D.A custom column built with Text.Combine
Explanation: Change Type > Using Locale lets you tell Power Query which regional convention to apply when it parses the text, so day-first, month-first and month-name strings all resolve to the Date data type in one step. Parsing is done by the mashup engine rather than by hand-written rules, so new format variants keep working.
3What is the primary difference between Import mode and DirectQuery mode when connecting to a SQL Server database?
A.Import mode is faster because it applies weaker security than DirectQuery
B.Import caches data in the model; DirectQuery queries the source live
C.DirectQuery works with a wider range of data sources than Import
D.Import mode requires a Power BI Premium license while DirectQuery does not
Explanation: Import mode imports and caches data in Power BI's internal engine (VertiPaq), enabling fast query performance. DirectQuery leaves data in the source database and sends queries to the source in real-time when users interact with reports. Import provides better performance but requires scheduled refreshes, while DirectQuery shows live data but may have slower report performance.
4You need to combine data from two Excel files with identical structures located in the same SharePoint folder. Which Power Query approach is most efficient?
A.Import each file separately and create a relationship between them
B.Use the SharePoint folder connector to combine the files
C.Copy and paste data from both files into a single Excel file first
D.Use Append Queries to combine the tables after importing each file
Explanation: The SharePoint folder connector returns the file list for a document library, and the Combine Files experience builds a sample-file function that is applied to every file in the list. Because the list is re-read on each refresh, files added later are picked up automatically. The Folder connector does the same job for a local or UNC path.
5A Store dimension is identified only by Region plus StoreCode together, so no single column is unique. How do you make it relatable to the fact table?
A.Merge both columns into one key column
B.Create a relationship on both columns at once
C.Set the relationship cardinality to many-to-many
D.Sort both tables by Region and StoreCode
Explanation: A Power BI relationship matches on exactly one column per side, so a composite key has to be materialized first. Merge Region and StoreCode into a single concatenated key in both the dimension and the fact table, using a separator that cannot appear inside either value, then build the one-to-many relationship on that column. Hide the key from report view, since it carries no analytical meaning.
6You need to create a reusable parameter for a file path that will be used across multiple queries. Which Power Query feature should you use?
A.Create a custom function
B.Create a Query Parameter
C.Use a global variable in Advanced Editor
D.Hardcode the path in each query
Explanation: Query Parameters in Power Query allow you to create reusable values that can be referenced across multiple queries. Parameters are especially useful for values that might change, such as file paths, server names, or date ranges. They can be easily updated in one place and provide a cleaner, more maintainable solution than hardcoding values.
7What happens when you select "Remove Duplicates" on a column in Power Query?
A.It deletes duplicate values from the data source permanently
B.It removes rows where all column values are identical to another row
C.It keeps only the first row per distinct value in that column
D.It creates a separate table with only the duplicate rows
Explanation: Remove Duplicates evaluates only the columns you selected. Rows whose selected column repeats a value seen earlier are dropped, and the first occurrence is kept in the order the rows currently appear, so the step is order-sensitive. The transformation applies to the query output only and never changes the source. Select every column first if you want a row treated as duplicate only when all its values match.
8You have a column with full names in the format "LastName, FirstName" and need to split it into two separate columns. Which M function would achieve this?
A.Text.BeforeDelimiter and Text.AfterDelimiter
B.Text.Start and Text.End with a fixed character count
C.Text.Split followed by Text.Combine
D.Text.Replace paired with Text.Insert
Explanation: The Text.BeforeDelimiter and Text.AfterDelimiter functions in M language are designed to split text at a specified delimiter. For "LastName, FirstName", Text.BeforeDelimiter([Name], ", ") returns "LastName" and Text.AfterDelimiter([Name], ", ") returns "FirstName". This is the most efficient approach for splitting text at a specific delimiter.
9What is the purpose of the Privacy Levels feature in Power Query?
A.To restrict who can open the published report in the Power BI service
B.To control whether sources may be combined
C.To encrypt data in transit between the source and Power BI
D.To set row-level security rules for report consumers
Explanation: Privacy levels classify each source as Public, Organizational or Private and stop the mashup engine from sending values from a more sensitive source to a less sensitive one. When two sources are isolated this way, Power Query buffers them separately instead of folding one combined query, which protects the data but can slow refresh.
10You need to unpivot a table that has months as columns (Jan, Feb, Mar, etc.) and create a single "Month" column with the values in a "Sales" column. Which transformation should you use?
A.Transpose the table
B.Pivot Column using Month
C.Unpivot Columns
D.Reverse Rows and rename
Explanation: The Unpivot Columns transformation converts column headers into values in a new column, with the corresponding cell values placed in another column. This transforms wide data (months as columns) into long format (months as rows), which is the proper structure for analysis in Power BI. This is a common requirement when working with crosstab or matrix-style data sources.

About the PL-300 Exam

The Microsoft Power BI Data Analyst Associate (PL-300) certification validates your ability to prepare, model, visualize, and secure data using Microsoft Power BI. The exam covers four domains: 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%). This certification is ideal for data analysts, BI professionals, and anyone who works with data visualization and business intelligence.

Questions

40 scored questions

Time Limit

100 minutes

Passing Score

700/1000 (70%)

Exam Fee

$165 USD (varies by region) (Microsoft)

PL-300 Exam Content Outline

25-30%

Prepare the data

Connect to data sources, transform data using Power Query, clean and shape data, create calculated columns using M language, and configure data loading options (import vs DirectQuery)

25-30%

Model the data

Design star schema, create and manage relationships, build calculated columns and measures using DAX, implement time intelligence, create hierarchies, and optimize model performance

25-30%

Visualize and analyze the data

Create reports and dashboards, use various visual types, implement filters and slicers, create bookmarks and tooltips, use AI features (Copilot, Key Influencers, Q&A), and design for accessibility

15-20%

Manage and secure Power BI

Create and manage workspaces, configure row-level security (RLS), manage datasets and dataflows, configure gateways, implement sensitivity labels, and use deployment pipelines

How to Pass the PL-300 Exam

What You Need to Know

  • Passing score: 700/1000 (70%)
  • Exam length: 40 questions
  • Time limit: 100 minutes
  • Exam fee: $165 USD (varies by region)

Keys to Passing

  • Work through all 316 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

PL-300 Study Tips from Top Performers

1Focus on Domain 2 (Model the data) — DAX and data modeling are the most technically challenging and heavily weighted areas
2Master DAX context — understand the difference between row context and filter context thoroughly
3Practice Power Query extensively — know how to clean, transform, and shape data from various sources
4Build complete solutions — practice creating end-to-end reports from raw data to finished dashboard
5Understand star schema design — know fact tables vs dimension tables and why relationships matter
6Study time intelligence DAX — SAMEPERIODLASTYEAR, DATESYTD, and TOTALYTD appear frequently
7Learn workspace roles and RLS — know the difference between Admin, Member, Contributor, and Viewer roles
8Complete 200+ practice questions and score 80%+ consistently before scheduling the exam
9Use Power BI Desktop daily — hands-on experience is essential for understanding the nuances of the tool

Frequently Asked Questions

What is the PL-300 passing score?

The Microsoft PL-300 exam requires a passing score of 700 out of 1000, which is approximately 70%. The exam has 40-60 questions to be completed in 100 minutes. The exact number of questions varies as Microsoft uses unscored pretest questions. There is no penalty for incorrect answers, so candidates should attempt all questions.

How hard is the PL-300 exam?

The PL-300 has an estimated pass rate of 65-75% for well-prepared candidates. The exam is considered moderately difficult as it tests both theoretical knowledge and practical skills in Power BI. Candidates with 3-6 months of hands-on Power BI experience and 40-60 hours of study typically pass on their first attempt. The most challenging areas are typically DAX calculations and data modeling concepts.

What are the four domains of the PL-300 exam?

The four exam domains are: Domain 1 — Prepare the data (25-30%): Connect to data sources, use Power Query Editor, transform and clean data, and work with the M language; Domain 2 — Model the data (25-30%): Design star schema, create relationships, write DAX measures and calculated columns, and implement time intelligence; Domain 3 — Visualize and analyze the data (25-30%): Create reports, use various visuals, implement interactivity, and leverage AI features; Domain 4 — Manage and secure Power BI (15-20%): Workspaces, RLS, dataflows, gateways, and deployment pipelines.

How long should I study for the PL-300 exam?

Most candidates need 40-60 hours of study time over 4-6 weeks. Candidates with regular Power BI experience may need less time. Key study activities: 1) Complete Microsoft Learn learning paths for PL-300; 2) Practice Power Query transformations extensively; 3) Master DAX fundamentals including context, iterators, and time intelligence; 4) Build complete reports from scratch; 5) Study security features like RLS and workspace roles; 6) Complete 200+ practice questions and score 80%+ consistently before scheduling.

Is the PL-300 certification worth it in 2026?

Yes — PL-300 is highly valuable for data professionals: 1) Power BI is the leading business intelligence platform with over 200,000 customers; 2) Power BI skills are in high demand with competitive salaries (average $85,000-$120,000 for data analysts); 3) It validates practical skills that employers specifically seek; 4) It is a prerequisite for the Power BI Data Engineer certification; 5) The certification is valid for one year but can be renewed annually via free Microsoft Learn assessments.

What is the difference between PL-300 and DA-100?

DA-100 was retired in March 2023 and replaced by PL-300. The content is largely similar, but PL-300 includes updated features and reduced emphasis on some legacy topics. Key differences: PL-300 includes Copilot AI features, datamarts, and updated Power BI service features; some topics like paginated reports have reduced emphasis; the exam format and passing score remain the same. If you studied for DA-100, you are well-prepared for PL-300 with some updates.

What DAX functions should I know for the exam?

Key DAX functions to master: Aggregation functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT); Filter functions (FILTER, ALL, ALLEXCEPT, REMOVEFILTERS); Iterator functions (SUMX, AVERAGEX, COUNTX); Time intelligence (SAMEPERIODLASTYEAR, DATESYTD, TOTALYTD, PARALLELPERIOD); Logical functions (IF, SWITCH, AND, OR); Table functions (VALUES, DISTINCT, CALCULATETABLE); Relationship functions (RELATED, RELATEDTABLE). Focus on understanding row context vs filter context.

What Power Query transformations are tested?

Key Power Query skills: Connecting to various data sources (SQL, Excel, web, SharePoint); Data profiling and quality assessment; Cleaning operations (remove duplicates, replace values, split columns); Transformations (pivot/unpivot, merge/append queries, group by); Adding custom columns using M language; Creating and using query parameters; Handling errors and data types; Understanding query folding for performance optimization.