-/ 1000
Estimated score
Answer at least 20 questions (all domains) to see an estimated score. Pass = 700.
Microsoft certification prep
PL-300 Practice Exam: Microsoft Power BI Data Analyst
Practice questions & a mock exam built to feel like the real thing: English questions, 6 question types, case studies, a 100-minute timer and a 1000-point score (pass 700). An explanation for every question.
116 questions26 free4 domain100 minutes
Your exam readiness
Progress is saved on this device. Sign in to save it to your account.
Simulation history
No simulations yet. Try the free mini simulation to feel the exam experience.
Choose how to study
Study mode
One question per screen. Answer, press Check and instantly see whether you are right, with an explanation and a Microsoft Learn link. Best for understanding the material.
Exam mode (simulation)
Real exam look & rules: a running timer, Mark for review, a Review screen, case studies and sections you cannot return to. Score & explanations at the end, scaled to 1000 (pass 700).
The real PL-300 exam format
100 minutes
Answering time. About 120 minutes in the seat in total (agreement, survey, instructions).
40-60 questions
The count varies per candidate. Expect a case study and a series of repeated-scenario questions.
Pass 700 / 1000
A scaled score, not a percentage. Wrong answers are not penalized: answer every question.
Open book: Microsoft Learn
During the exam you can open Microsoft Learn from a button on the exam screen, but the timer keeps running. Use it only to confirm details.
English
Offered in several languages, but not Indonesian. That is why every question here is in English.
Valid for 1 year
Renew for free with an online renewal assessment on Microsoft Learn before it expires.
Question types you will meet (all included here)
- Multiple choiceOne correct answer from 4 to 6 options.
- Multiple answers"Choose two / three". Each correct selection is worth one point.
- Yes / NoSeveral statements, each answered Yes or No.
- Build a sequenceMove the right actions into the Answer Area and order them. Some actions are distractors.
- Dropdown (hot area)Complete DAX / Power Query code or a sentence with dropdowns.
- MatchMatch requirements to the right feature or visual.
- Case studyA long company scenario with tabs (Overview, Requirements, …) followed by 4 to 8 questions. Once you finish the section you cannot go back.
- Repeated scenario"Does this meet the goal?" The same scenario with a different solution each time. Answered questions cannot be reopened.
Skills measured
Summary of the official outline as of 20 April 2026. Weight = share of questions on the exam. Always check the official study guide for the latest version.
Prepare the data
Get or connect to data9 questions
- Identify and connect to data sources or a shared semantic model
- Change data source settings, including credentials and privacy levels
- Choose between DirectQuery and Import
- Create and modify parameters
Profile and clean the data6 questions
- Evaluate data, including data statistics and column properties
- Resolve inconsistencies, unexpected or null values, and data quality issues
- Resolve data import errors
Transform and load the data14 questions
- Select appropriate column data types
- Create and transform columns
- Group and aggregate rows
- Pivot, unpivot, and transpose data
- Convert semi-structured data to a table
- Create fact tables and dimension tables
- Identify when to use reference or duplicate queries and the resulting impact
- Merge and append queries
- Identify and create appropriate keys for relationships
- Configure data loading for queries
Model the data
Design and implement a data model9 questions
- Configure table and column properties
- Implement role-playing dimensions
- Define a relationship's cardinality and cross-filter direction
- Create a common date table
- Identify use cases for calculated columns and calculated tables
Create model calculations by using DAX17 questions
- Create single aggregation measures
- Use the CALCULATE function
- Implement time intelligence measures
- Use basic statistical functions
- Create semi-additive measures
- Create a measure by using quick measures
- Create calculated tables or columns
- Create calculation groups
Optimize model performance6 questions
- Improve performance by identifying and removing unnecessary rows and columns
- Identify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query view
- Improve performance by reducing granularity
Visualize and analyze the data
Create reports11 questions
- Select an appropriate visual
- Format and configure visuals
- Apply and customize a theme
- Configure conditional formatting
- Apply slicing and filtering
- Configure the report page
- Choose when to use a paginated report
- Create visual calculations by using DAX
- Create a narrative visual with Copilot
- Use Copilot to create a new report page
Enhance reports for usability and storytelling11 questions
- Configure bookmarks
- Create custom tooltips
- Edit and configure interactions between visuals
- Configure navigation for a report
- Apply sorting to visuals
- Configure sync slicers
- Group and layer visuals by using the Selection pane
- Configure drillthrough navigation
- Configure export settings
- Design reports for mobile devices
Identify patterns and trends6 questions
- Use the Analyze feature in Power BI
- Use grouping, binning, and clustering
- Use AI visuals
- Use reference lines, error bars, and forecasting
- Detect outliers and anomalies
- Use Copilot to summarize the underlying semantic model
Manage and secure Power BI
Create and manage workspaces and assets13 questions
- Create and configure a workspace
- Configure and update a workspace app
- Publish, import, or update items in a workspace
- Create dashboards
- Choose a distribution method
- Configure subscriptions and data alerts
- Promote or certify Power BI content
- Identify when a gateway is required
- Configure a semantic model scheduled refresh
Secure and govern Power BI items14 questions
- Assign workspace roles
- Configure item-level access
- Configure access to semantic models
- Implement row-level security roles
- Configure row-level security group membership
- Apply sensitivity labels
4-week study plan
- Week 1
Prepare the data
Power Query: data sources, profiling, merge / append, unpivot.
- Week 2
Model the data
Star schema, relationships, date table, CALCULATE, time intelligence.
- Week 3
Visualize & analyze
Choosing visuals, bookmarks, drillthrough, tooltips, AI visuals, Copilot.
- Week 4
Manage & secure + mock exams
Workspaces, apps, gateways, refresh, RLS. Then 2 to 3 full simulations until you score above 800 consistently.
Exam-day strategy
Manage your time
±100 minutes for ±50 questions = 2 minutes each. Unsure? Pick your best answer, tick Mark for review, move on.
Case study: read the question first
Open the question, then look up the facts you need in the Requirements tab. No need to memorize the whole scenario.
Spot the constraint keywords
"minimize development effort", "least privilege", "minimize model size" decide which answer is BEST when several would work.
Answer everything
There is no penalty. A blank answer is always 0, a guess still has a chance.
Official Microsoft resources
PL-300 study guide (official)
Full skills measured list and its change log.
Certification page & scheduling
Schedule the exam (Pearson VUE, online or at a test center), local pricing, free practice assessment.
Exam sandbox (UI demo)
Try the buttons and question types of the real exam app before exam day.
Microsoft Learn: Power BI
Free Microsoft learning modules for every domain.
Every question here is ORIGINAL, written by INSYNTIVE: topics, style and difficulty follow the PL-300 outline, but they are not copies of exam questions (sharing real exam content breaks the Microsoft agreement). INSYNTIVE is not affiliated with Microsoft. Microsoft, Power BI and PL-300 are trademarks of Microsoft Corporation.
FAQ
How long is the PL-300 exam and how many questions are there?
100 minutes of answering time (about 120 minutes in the seat) for 40-60 questions, possibly including a case study and repeated-scenario questions.
What is the PL-300 passing score?
700 on a scale of 1 to 1000. It is a scaled score, so it is not the same as 70% correct. This simulation uses a proportional scale as an estimate.
Are these the same questions as the real exam?
No. Every question is written from scratch following the official skills measured, with the same question types and wording style. The goal is understanding, not memorizing.
Is PL-300 offered in Indonesian?
No. The exam is offered in several languages (including English), but not Indonesian. That is why the questions here are in English with explanations in Indonesian.
How much does the PL-300 exam cost?
Microsoft sets the price per country and it can change. Check the current price for your country on the official certification page when you schedule.
How long is the PL-300 certification valid?
One year. Renew it for free with an online renewal assessment on Microsoft Learn (opens 6 months before it expires).
For INSYNTIVE Academy members
Unlock all 116 questions + full simulations
- Unlimited 100-minute full simulations: questions are re-drawn every time, rarely seen ones first.
- Every study-mode question + case studies & repeated-scenario sets, all with explanations.
- Progress & score history saved to your account, plus the full Power BI course, DAX & Power Query practice, templates and member classes.