Power BI Certification exam answers 2026: This page lists all 100 questions of the official Power BI Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.
About this certification: Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports.
| Certification | Power BI Certification |
| Provider | Itronix Solutions |
| Category | Data Science & Analytics |
| Total questions | 100 multiple-choice questions |
| Marks | 1 mark per question (100 marks) |
| Passing score | 80% (80 out of 100) |
| Retake | Available if you do not pass |
| Certificate | Verifiable online certificate |
Take the exam: Power BI Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.
Power BI Exam Questions and Answers
Questions 1 to 25
1. What is Power BI?
Correct answer: A. A business analytics tool
2. Which of the following is a data visualization feature in Power BI?
Correct answer: A. Charts
3. Which programming language is used to create custom visuals in Power BI?
Correct answer: A. R
4. Which of the following is NOT a data source that can be used in Power BI?
Correct answer: A. Adobe Photoshop files
5. Contains reference data such as descriptive attributes__________________
Correct answer: B. Dimension table
6. What is the recommend method to share your reports?
Correct answer: B. Publish them to the Power BI service
7. Berikut contoh fungsi COUNTING, kecuali_______________
Correct answer: B. MAX
8. Creates the connection between Power BI cloud-based data and the data source located on-premises_______________
Correct answer: B. Gateway
9. In which year did Microsoft discharge an extra administration called Power BI Embedded?
Correct answer: C. 2016
10. The principal arrival of Power BI depended on
Correct answer: C. Microsoft Excel
11. Power BI was first discharged to the overall population
Correct answer: C. 2015
12. What is the best way to shape your data for Power BI?
Correct answer: C. User a star schema.
13. What is NOT a built-in Power BI visual?
Correct answer: D. Power KPI
14. Facebook, Twilio, GitHub, and MailChimp are all examples of Power BI
Correct answer: D. Online services
15. Power BI Pro has a limit of ____________GB data in free version.
Correct answer: D. 10
16. Which three views are available in Power BI Desktop?
Correct answer: D. Both A and B
17. What is the common flow of activity in Power BI?
Correct answer: A. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile
18. Which of the following illustrates a Many to One relationship?
Correct answer: A. Many banana trees planted in a garden
19. The following are examples of the AGGREGATION function except__________________
Correct answer: A. Semua benar
20. A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be_________________
Correct answer: A. One to Many
21. Power BI is:
Correct answer: B. Microsoft’s business intelligence and data visualisation platform
22. Power BI Desktop is used to:
Correct answer: B. Build data models and reports
23. The Power BI Service is:
Correct answer: A. The cloud platform for sharing and collaborating on reports
24. Power BI Mobile lets users:
Correct answer: A. View reports and dashboards on phones and tablets
25. Power Query in Power BI is used to:
Correct answer: D. Connect, clean and transform data
Questions 26 to 50
26. The language used in Power Query is:
Correct answer: C. M
27. DAX stands for:
Correct answer: B. Data Analysis Expressions
28. DAX is used to create:
Correct answer: B. Measures, calculated columns and tables
29. A measure in Power BI is:
Correct answer: D. A calculation evaluated dynamically based on filter context
30. A calculated column is:
Correct answer: B. Computed row by row and stored in the model
31. Filter context refers to:
Correct answer: C. The filters applied to a calculation from visuals, slicers and filters
32. Row context exists:
Correct answer: C. When iterating over rows, such as in calculated columns
33. CALCULATE in DAX:
Correct answer: B. Evaluates an expression in a modified filter context
34. SUMX is an example of:
Correct answer: A. An iterator function
35. RELATED in DAX is used to:
Correct answer: B. Fetch a value from a related table on the one side
36. ALL in DAX:
Correct answer: C. Removes filters from a table or column
37. DIVIDE in DAX is preferred because it:
Correct answer: B. Handles division by zero safely
38. Time intelligence functions such as TOTALYTD require:
Correct answer: D. A proper date table
39. A star schema has:
Correct answer: A. A central fact table connected to dimension tables
40. A fact table contains:
Correct answer: A. Measurable events such as sales transactions
41. A dimension table contains:
Correct answer: B. Descriptive attributes such as product or customer details
42. Relationship cardinality one-to-many means:
Correct answer: D. One row in a table relates to many rows in another
43. Cross-filter direction controls:
Correct answer: A. How filters propagate between related tables
44. Import mode in Power BI:
Correct answer: A. Loads data into the in-memory model
45. DirectQuery mode:
Correct answer: A. Queries the data source live without importing
46. Scheduled refresh in the Power BI Service:
Correct answer: A. Updates imported data automatically
47. An on-premises data gateway is needed to:
Correct answer: B. Refresh data from on-premises sources in the cloud service
48. A report in Power BI is:
Correct answer: A. One or more pages of interactive visuals
49. A dashboard in Power BI is:
Correct answer: A. A single-page canvas of pinned tiles in the service
50. A slicer is:
Correct answer: B. A visual used to filter other visuals
Questions 51 to 75
51. Drill-down allows users to:
Correct answer: B. Navigate from summary to more detailed levels
52. Drillthrough lets users:
Correct answer: D. Navigate to a detail page filtered for a selected item
53. Bookmarks capture:
Correct answer: B. The current state of a report page
54. Tooltips pages provide:
Correct answer: C. Custom detail when hovering over visuals
55. Conditional formatting in visuals:
Correct answer: C. Changes colours based on values or rules
56. A KPI visual shows:
Correct answer: A. Progress toward a target
57. A card visual displays:
Correct answer: C. A single key number
58. A matrix visual is similar to:
Correct answer: A. A pivot table
59. Row-level security (RLS) restricts:
Correct answer: D. Which data rows users can see
60. Workspaces in the Power BI Service are used to:
Correct answer: D. Collaborate and organise content
61. A Power BI app is:
Correct answer: D. A packaged collection of content distributed to users
62. Power BI Pro licences allow:
Correct answer: B. Publishing and sharing content with other Pro users
63. Q&A in Power BI lets users:
Correct answer: B. Ask questions in natural language to create visuals
64. Quick Insights / Analyze features help to:
Correct answer: D. Find patterns automatically
65. Merge Queries in Power Query:
Correct answer: A. Joins tables based on matching columns
66. Append Queries in Power Query:
Correct answer: B. Stacks rows from multiple tables
67. Unpivot columns transforms:
Correct answer: B. Wide columns into attribute-value rows
68. Changing data types in Power Query ensures:
Correct answer: A. Correct calculations and sorting
69. Removing unnecessary columns improves:
Correct answer: D. Model size and performance
70. Query folding means:
Correct answer: B. Power Query transformations are pushed back to the data source
71. Performance Analyzer shows:
Correct answer: C. How long visuals and queries take to load
72. Best practice is to prefer:
Correct answer: B. Measures over calculated columns for aggregations
73. A date table should be:
Correct answer: B. Continuous with no missing dates and marked as a date table
74. Custom visuals can be imported from:
Correct answer: C. AppSource
75. Themes in Power BI control:
Correct answer: A. Colours, fonts and visual formatting
Questions 76 to 100
76. Paginated reports are designed for:
Correct answer: B. Pixel-perfect printable reports
77. Dataflows in the service allow:
Correct answer: D. Reusable Power Query transformations in the cloud
78. Data alerts on dashboard tiles notify users when:
Correct answer: B. A value crosses a threshold
79. Sensitivity labels help to:
Correct answer: D. Classify and protect sensitive data
80. Power BI can connect to sources such as:
Correct answer: B. Excel, SQL Server, SharePoint and many others
81. Calculated tables in DAX are created using:
Correct answer: D. DAX table expressions
82. FILTER in DAX returns:
Correct answer: D. A table filtered by a condition
83. COUNTROWS in DAX returns:
Correct answer: B. The number of rows in a table
84. DISTINCTCOUNT returns:
Correct answer: B. The number of unique values in a column
85. SAMEPERIODLASTYEAR is used to:
Correct answer: A. Compare values with the same period in the previous year
86. Variables in DAX (VAR) help to:
Correct answer: D. Improve readability and performance of measures
87. Hierarchies in Power BI enable:
Correct answer: A. Drill-down from year to quarter to month, for example
88. Sync slicers allows:
Correct answer: B. One slicer to filter multiple report pages
89. The Selection pane manages:
Correct answer: C. Visibility and order of objects on a page
90. Export to PDF or PowerPoint is used to:
Correct answer: B. Share static versions of reports
91. Usage metrics show:
Correct answer: A. How reports are being viewed
92. Power BI Embedded allows:
Correct answer: D. Embedding reports into custom applications
93. Good report design should:
Correct answer: A. Highlight key insights with clear, uncluttered visuals
94. The Analyze in Excel feature lets users:
Correct answer: A. Explore a Power BI dataset using Excel pivot tables
95. Composite models allow:
Correct answer: D. Combining Import and DirectQuery sources
96. Incremental refresh helps to:
Correct answer: C. Refresh only new or changed data in large datasets
97. The main goal of Power BI is to:
Correct answer: D. Turn data into interactive insights for decision-making
98. Field parameters in Power BI allow users to:
Correct answer: D. Switch the measures or dimensions shown in a visual
99. The Fields pane lists:
Correct answer: D. Tables, columns and measures in the model
100. A waterfall chart shows:
Correct answer: A. How an initial value is affected by positive and negative changes
How to Pass the Power BI Exam
- Read every question carefully; most options look similar, so look for the most precise answer.
- Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
- You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
- If you do not clear it on the first attempt, review the questions you missed and use the retake option.
Frequently Asked Questions
How many questions are in the Power BI Certification exam?
The exam has 100 multiple-choice questions, each worth 1 mark.
What is the passing score for the Power BI Certification?
You need at least 80% (80 out of 100) to pass and receive the certificate.
Can I retake the Power BI Certification exam?
Yes. If you score below 80%, you can retry the test after reviewing the topics.
Is the Itronix certificate verifiable?
Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.
More Data Science & Analytics Certification Answers
- Big Data Certification Exam Answers
- Data Analyst Professional Certification Exam Answers
- Data Science Certification Exam Answers
- Data Visualization with Python using Matplotlib Exam Answers
- Google Data Analytics Certification Exam Answers
- SPSS Statistics Certification Exam Answers
- Tableau for Data Science Certification Exam Answers
Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.
Priya Dogra – Free Certifications, Exam Answers & Career Guides Free certification exam answers, courses, scholarships and career guides for learners worldwide