• 64 questions

Power BI Certification Practice Test

Questions for Exam PL-300, Microsoft Power BI Data Analyst, each answer linked to the Microsoft Learn page behind it.

In the Group by dialog, which operation keeps every row of each group as a nested table, with no aggregation?

Pick an answer, then press Check answer. Then you see Correct or Not quite, with the reason. Keys: A to D pick, Enter checks.

Print covers the next 50 questions. Share this set copies a link to the same questions in the same order.

Exam mode: 50 questions, 100 minutes.

More options

Unofficial practice questions, not affiliated with Microsoft. Bank checked October 10, 2026.

Next step Next: Excel certification testAnother IT certification? Pick it

All 64 questions

Prepare the data 17

  • A Power Query parameter has Suggested Values set to List of values. What can a user still do when setting its current value? Microsoft Learn, Using parameters, Parameter properties
  • A query merges a workbook of staff salaries with a table from a public web page. Which privacy level on the workbook stops its data from folding into any other source? Microsoft Learn, Privacy levels, introduction
  • A sheet has a Region column and one column per month. After which unpivot command does a month column that first appears at a later refresh stay a column? Microsoft Learn, Unpivot columns, Unpivot only selected columns
  • A staging query exists only to be merged into two other queries. What does the data reduction guidance say to do with it? Microsoft Learn, Data reduction techniques for Import modeling, Disable Power Query query load
  • A warehouse table is too large to copy, and a stock report must reflect the source each time a reader changes a slicer. Which connection choice sends a query to the source for every visual? Microsoft Learn, DirectQuery in Power BI, DirectQuery connections
Show all 64 questions (59 more)

Prepare the data, continued

  • After a Changed Type step, a few cells of a column read Error, but the query still loads. What kind of error is this? Microsoft Learn, Dealing with errors in Power Query, Cell-level error
  • Column distribution reports 5 distinct and 2 unique values for a City column. What does unique count? Microsoft Learn, Using the data profiling tools, Column distribution
  • Column quality shows a 40,000-row column as fully valid, yet the load reports errors in it. Which default setting explains the gap? Microsoft Learn, Using the data profiling tools, introduction
  • How does a query made with Reference differ from one made with Duplicate? Microsoft Learn, Using the Queries pane, Referencing a query
  • In a Power BI model, what decides whether a table acts as a dimension table or a fact table? Microsoft Learn, Understand star schema and the importance for Power BI, Star schema relevance to Power BI semantic models
  • In Power BI Desktop you change a table from DirectQuery to Import. What can you no longer do with that table afterwards? Microsoft Learn, Table storage mode in Power BI semantic models, See the storage mode of a table
  • In the Group by dialog, which operation keeps every row of each group as a nested table, with no aggregation? Microsoft Learn, Grouping or summarizing rows, Operations available
  • Orders is the left table of a merge and Customers the right. Which join kind returns only the orders with no matching customer? Microsoft Learn, Left anti join, introduction
  • Remove duplicates on a City column leaves both Oslo and OSLO in the table. Why? Microsoft Learn, Working with duplicate values, Remove duplicate rows in Power Query
  • Two tables are appended. Only the first has a Discount column. What does Discount hold for the rows that came from the second table? Microsoft Learn, Append queries, introduction
  • What does a refresh of a Direct Lake semantic model copy? Microsoft Learn, Direct Lake overview, introduction
  • Which Power Query data type suits invoice amounts that must not pick up floating-point imprecision? Microsoft Learn, Data types in Power Query, introduction

Model the data 17

  • A fact table holds a row per order line, but every report is by month and product. Which change shrinks the model most, at the cost of line detail? Microsoft Learn, Data reduction techniques for Import modeling, Group by and summarize
  • A margin figure must change as a reader moves a slicer on a report page. What should hold the calculation? Microsoft Learn, Create measures for data analysis in Power BI Desktop, introduction
  • A measure is DIVIDE([Profit], [Sales]) with no third argument. What does it return where [Sales] is 0? Microsoft Learn, DIVIDE, Parameters
  • A measure must total sales by ship date across an inactive relationship to the Date table. Which function, used in CALCULATE, makes that relationship apply? Microsoft Learn, Understand star schema and the importance for Power BI, Role-playing dimensions
  • A slicer selects Blue on Product[Color]. What does CALCULATE(SUM(Sales[Amount]), Product[Color] = "Red") return? Microsoft Learn, CALCULATE, Examples
  • A stock-on-hand measure should show each month's closing figure, never the sum of its days. Which function evaluates an expression on the month's last date? Microsoft Learn, CLOSINGBALANCEMONTH, introduction
  • A year-to-date sales measure must start again after June 30 each year. Which change does that? Microsoft Learn, TOTALYTD, Parameters
  • In a calculation item, which function stands in for whichever measure the visual is using? Microsoft Learn, Create calculation groups, Add a new calculation group in model view
  • Marking a table as a date table fails on validation of its Date column. Which fault would cause that? Microsoft Learn, Set and use date tables in Power BI Desktop, How to set your own date table
  • On a chart axis the Month Name column runs April, August, December. Which column property puts the months in calendar order? Microsoft Learn, Sort one column by another column in Power BI, Set the column to use for sorting
  • Orders[CustomerID] holds 40 different IDs, and some rows are blank. What does DISTINCTCOUNT(Orders[CustomerID]) return? Microsoft Learn, DISTINCTCOUNT, Remarks
  • Performance analyzer logs a map visual with a short DAX query time and a long Visual display time. Where is the time going? Microsoft Learn, Use Performance Analyzer to examine report performance, Use Performance Analyzer
  • Product[ProductID] is the one side of a one-to-many relationship. A refresh tries to load a duplicate ProductID into Product. What happens? Microsoft Learn, Model relationships in Power BI Desktop, Cardinality
  • Sales has OrderDate and ShipDate columns, each related to the same Date table. How many of the two relationships can be active? Microsoft Learn, Model relationships in Power BI Desktop, Make this relationship active
  • Sales has Quantity and UnitPrice columns and no line amount. Which measure adds up Quantity times UnitPrice row by row? Microsoft Learn, SUMX, introduction
  • Which statement must every query run in DAX query view contain? Microsoft Learn, Work with DAX query view, DAX queries
  • You build a year-over-year change with a quick measure. Where can you read the DAX it wrote? Microsoft Learn, Use quick measures for common calculations, Learn DAX by using quick measures

Visualize and analyze the data 18

  • A 300-row invoice listing must print in full across several pages, with page headers and footers. Which kind of report should you build? Microsoft Learn, When to use paginated reports in Power BI, introduction
  • A finance page must show how opening cash is raised and lowered by a run of gains and losses until it reaches closing cash. Which visual fits? Microsoft Learn, Visualizations overview in Power BI, Waterfall charts
  • A report page has a mobile-optimized view. When does the Power BI mobile app show that view? Microsoft Learn, Create mobile-optimized Power BI reports, introduction
  • A small report page should pop up when a reader hovers over a bar. What must be set on that page? Microsoft Learn, Create report tooltips in Power BI, Configure your tooltip report page
  • A Year slicer on page 1 is synced to page 2 but is not made visible there. A reader picks 2025 on page 1. What does page 2 show? Microsoft Learn, Slicers overview in Power BI, Sync and use slicers on other pages
  • Cells in a Margin column should turn red, amber or green at fixed thresholds that you type in. Which format style does that? Microsoft Learn, Apply conditional formatting in tables and matrices, Format background or font color
  • Find anomalies cannot be turned on for a line chart of daily revenue that has Region in the legend. What must change? Microsoft Learn, Anomaly detection tutorial for Power BI, Considerations and limitations
  • In a decomposition tree, what does the High value AI split do? Microsoft Learn, Create and view decomposition tree visuals in Power BI, AI splits
  • Keyboard users reach the visuals of a page in a confusing order. Where do you set the order the Tab key follows? Microsoft Learn, Design Power BI reports for accessibility, Tab order
  • The Page refresh card is missing from the Format pane of a report page. What is the likely cause? Microsoft Learn, Automatic page refresh in Power BI, Author reports with automatic page refresh in Power BI Desktop
  • Selecting a bar highlights part of a nearby column chart, and you want it to filter that chart instead. Where is this set in Power BI Desktop? Microsoft Learn, Change how visuals interact in a Power BI report, Enable the visual interaction controls
  • What does a Copilot narrative visual read to write its summary? Microsoft Learn, Create a narrative visual with Copilot for Power BI, Before you start
  • Which of these can be put into bins of a set size in Power BI Desktop? Microsoft Learn, Use grouping and binning in Power BI Desktop, Use binning
  • Which option of a report bookmark holds the filter and slicer states? Microsoft Learn, Create report bookmarks in Power BI to share insights and build stories, Power BI service
  • You add a field to the drillthrough well of a page. What does Power BI add to that page automatically? Microsoft Learn, Drillthrough in Power BI reports: Navigate to detailed insights, Create a drillthrough page
  • You add a running sum to a chart as a visual calculation. Where is it stored? Microsoft Learn, Visual calculations, introduction
  • You apply a new report theme, and one chart keeps its old colors. What is the likely reason? Microsoft Learn, Use report themes in Power BI, introduction
  • You right-click a point on a line chart and choose Analyze > Explain the increase. Which change does the insight explain? Microsoft Learn, Apply insights in Power BI to explain fluctuations in visuals, Use insights

Manage and secure Power BI 12

  • A .pbix file that carries a sensitivity label is published to a workspace for the first time. What receives the file's label? Microsoft Learn, How to apply sensitivity labels in Power BI, Work with sensitivity labels on uploaded or downloaded files
  • A semantic model has row-level security roles. To users of which workspace role do the RLS filters apply? Microsoft Learn, Row-level security (RLS) with Power BI, introduction
  • A user with the Viewer role needs Analyze in Excel on a semantic model in the workspace. What should you give them? Microsoft Learn, Roles in workspaces in Power BI, Workspace roles
  • How many scheduled refreshes a day does Power BI allow for a semantic model on shared capacity? Microsoft Learn, Data refresh in Power BI, Data refresh
  • On which dashboard tiles can a data alert be set? Microsoft Learn, Data alerts in the Power BI service, introduction
  • One role must show each signed-in user only the rows that carry their own email address. Which filter on the table does that? Microsoft Learn, Row-level security (RLS) with Power BI, Common DAX filter patterns for RLS roles
  • Several report authors need DirectQuery to one SQL Server inside the company network. Which gateway fits? Microsoft Learn, On-premises data gateways in Power BI, Types of gateways
  • Where can a Power BI dashboard be created? Microsoft Learn, Introduction to dashboards for Power BI designers, introduction
  • Which is the lowest workspace role that can add, change and remove workspace content? Microsoft Learn, Roles in workspaces in Power BI, Workspace roles
  • Which kind of group cannot be added as a member of a row-level security role? Microsoft Learn, Row-level security (RLS) with Power BI, Add members to an RLS role
  • Who can certify a semantic model? Microsoft Learn, Endorse your content, introduction
  • You add a report to a workspace and update its app, but app users cannot find the new report. Why? Microsoft Learn, Publish a workspace app in Power BI, Add content to the app

How this list was compiled: Own questions, written to the four skill areas and weights of the study guide that Microsoft publishes for Exam PL-300: Microsoft Power BI Data Analyst at https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300 (skills measured as of April 20, 2026; read 2026-10-10), with the exam time from the certification page https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/ (read 2026-10-10). Facts were read on 2026-10-10 in the Microsoft Learn documentation for Power BI, Power Query, Microsoft Fabric and the DAX reference at learn.microsoft.com. Each question names the article and section it was written from and links to it. Licence: Own work. Every question, wrong choice, table name and explanation was written for this site from the public documentation named in each question. Nothing is copied or reworded from a Microsoft exam, the Microsoft practice assessment, a sample question or another practice product.

How it works

This unofficial Power BI certification practice test has 64 of our own questions, spread over the four skill areas of Microsoft's study guide for Exam PL-300. It is not affiliated with Microsoft, and nothing is taken from the real exam.

Read the full guide

What Exam PL-300 asks

Microsoft's study guide, with skills measured as of April 20, 2026 and read on October 10, 2026, weights four areas: 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 certification page allows 100 minutes.

What is not asked here

Microsoft's page says the real exam may have interactive components. Every question here has four choices and one right answer. License prices are left out. Power BI changes often, so a menu name or a limit can differ from the page an answer links to.

  • A Direct Lake refresh copies metadata and nothing else. An Import refresh copies the data itself.
  • Row-level security filters apply to workspace Viewers. Admins, Members and Contributors see every row.
  • DISTINCTCOUNT counts a blank as one value. DIVIDE returns BLANK when the denominator is zero and no alternate result is given.

Questions and answers

How many questions are on the PL-300 exam?

Microsoft publishes no count for PL-300. Its exam experience page says most of its certification exams have 40 to 60 questions. Exam mode here draws 50 of ours.

What is the passing score for the Power BI certification exam?

700 on a scale of 1 to 1,000, by Microsoft's study guide and its exam scoring page. Microsoft adds that a scaled score may not equal 70% of the points, so this page shows your percent right and no pass or fail.

Which exam is the Power BI certification?

Exam PL-300: Microsoft Power BI Data Analyst. It is the exam on Microsoft's page for the Microsoft Certified: Power BI Data Analyst Associate certification, which the page rates intermediate and lists with a renewal every 12 months.

Is this Power BI practice test free?

Yes. All 64 questions, their explanations with Microsoft Learn links and the timed exam mode are free, with no sign-up.

More tests

Show 7 more

Browse Safety and Trades