Wednesday , November 18 2026
Breaking News

Power BI Certification Exam Answers 2026 (All 100 Questions)

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?

A. A business analytics tool ✔
B. A graphic design tool
C. A project management software
D. A database management system

Correct answer: A. A business analytics tool

2. Which of the following is a data visualization feature in Power BI?

A. Charts ✔
B. Animation
C. Video editing
D. Word processing

Correct answer: A. Charts

3. Which programming language is used to create custom visuals in Power BI?

A. R ✔
B. Java
C. C#
D. Python

Correct answer: A. R

4. Which of the following is NOT a data source that can be used in Power BI?

A. Adobe Photoshop files ✔
B. Oracle databases
C. JSON files
D. Excel spreadsheets

Correct answer: A. Adobe Photoshop files

5. Contains reference data such as descriptive attributes__________________

A. Query table
B. Dimension table ✔
C. Power BI table
D. Fact table

Correct answer: B. Dimension table

6. What is the recommend method to share your reports?

A. Copy the .PBIX file to a file folder, and give coworkers access to that folder
B. Publish them to the Power BI service ✔
C. Create a PDF of the report, and share the PDF with others
D. None

Correct answer: B. Publish them to the Power BI service

7. Berikut contoh fungsi COUNTING, kecuali_______________

A. COUNTROWS
B. MAX ✔
C. COUNT
D. None

Correct answer: B. MAX

8. Creates the connection between Power BI cloud-based data and the data source located on-premises_______________

A. Query editor
B. Gateway ✔
C. Power BI service
D. Report view

Correct answer: B. Gateway

9. In which year did Microsoft discharge an extra administration called Power BI Embedded?

A. 2006
B. 1996
C. 2016 ✔
D. 2013

Correct answer: C. 2016

10. The principal arrival of Power BI depended on

A. Microsoft PowerPoint
B. Microsoft Word
C. Microsoft Excel ✔
D. Microsoft Outlook

Correct answer: C. Microsoft Excel

11. Power BI was first discharged to the overall population

A. 2014
B. 2013
C. 2015 ✔
D. 2016

Correct answer: C. 2015

12. What is the best way to shape your data for Power BI?

A. Load all tables
B. Include multiple objects
C. User a star schema. ✔
D. None of the above

Correct answer: C. User a star schema.

13. What is NOT a built-in Power BI visual?

A. Waterfall chart
B. Funnel chart
C. ArcGIS map
D. Power KPI ✔

Correct answer: D. Power KPI

14. Facebook, Twilio, GitHub, and MailChimp are all examples of Power BI

A. Database data sources
B. File data sources
C. Wiki data sources
D. Online services ✔

Correct answer: D. Online services

15. Power BI Pro has a limit of ____________GB data in free version.

A. 40
B. 30
C. 20
D. 10 ✔

Correct answer: D. 10

16. Which three views are available in Power BI Desktop?

A. Report
B. Data
C. Dashboard
D. Both A and B ✔

Correct answer: D. Both A and B

17. What is the common flow of activity in Power BI?

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 ✔
B. Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service
C. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop
D. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop

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?

A. Many banana trees planted in a garden ✔
B. Many gardens having no banana trees
C. 1 banana tree having many bananas on the tree
D. Many banana trees planted in more than 1 garden

Correct answer: A. Many banana trees planted in a garden

19. The following are examples of the AGGREGATION function except__________________

A. Semua benar ✔
B. Date Functions
C. Logical Functions
D. Aggregation Functions

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_________________

A. One to Many ✔
B. Many to Many
C. Many to One
D. One to One

Correct answer: A. One to Many

21. Power BI is:

A. A word processor
B. Microsoft’s business intelligence and data visualisation platform ✔
C. An email client
D. A database engine only

Correct answer: B. Microsoft’s business intelligence and data visualisation platform

22. Power BI Desktop is used to:

A. Only view shared dashboards on phones
B. Build data models and reports ✔
C. Host websites
D. Write emails

Correct answer: B. Build data models and reports

23. The Power BI Service is:

A. The cloud platform for sharing and collaborating on reports ✔
B. A desktop-only tool
C. A database
D. A coding IDE

Correct answer: A. The cloud platform for sharing and collaborating on reports

24. Power BI Mobile lets users:

A. View reports and dashboards on phones and tablets ✔
B. Build data models
C. Manage servers
D. Write DAX only

Correct answer: A. View reports and dashboards on phones and tablets

25. Power Query in Power BI is used to:

A. Write VBA
B. Send emails
C. Draw charts only
D. Connect, clean and transform data ✔

Correct answer: D. Connect, clean and transform data

Questions 26 to 50

26. The language used in Power Query is:

A. Python only
B. SQL only
C. M ✔
D. DAX

Correct answer: C. M

27. DAX stands for:

A. Data Access XML
B. Data Analysis Expressions ✔
C. Database Admin Extension
D. Dynamic Analytics Exchange

Correct answer: B. Data Analysis Expressions

28. DAX is used to create:

A. Only charts
B. Measures, calculated columns and tables ✔
C. Only data sources
D. Only themes

Correct answer: B. Measures, calculated columns and tables

29. A measure in Power BI is:

A. A visual
B. A stored column value
C. A data source
D. A calculation evaluated dynamically based on filter context ✔

Correct answer: D. A calculation evaluated dynamically based on filter context

30. A calculated column is:

A. A visual
B. Computed row by row and stored in the model ✔
C. A slicer
D. Calculated only at query time

Correct answer: B. Computed row by row and stored in the model

31. Filter context refers to:

A. The theme
B. The page size
C. The filters applied to a calculation from visuals, slicers and filters ✔
D. The data source path

Correct answer: C. The filters applied to a calculation from visuals, slicers and filters

32. Row context exists:

A. Only in Power Query
B. Never
C. When iterating over rows, such as in calculated columns ✔
D. Only in visuals

Correct answer: C. When iterating over rows, such as in calculated columns

33. CALCULATE in DAX:

A. Imports data
B. Evaluates an expression in a modified filter context ✔
C. Only adds numbers
D. Creates visuals

Correct answer: B. Evaluates an expression in a modified filter context

34. SUMX is an example of:

A. An iterator function ✔
B. A filter only
C. A data source
D. A visual type

Correct answer: A. An iterator function

35. RELATED in DAX is used to:

A. Sort data
B. Fetch a value from a related table on the one side ✔
C. Create tables
D. Delete relationships

Correct answer: B. Fetch a value from a related table on the one side

36. ALL in DAX:

A. Deletes data
B. Creates columns
C. Removes filters from a table or column ✔
D. Adds filters

Correct answer: C. Removes filters from a table or column

37. DIVIDE in DAX is preferred because it:

A. Is faster than all functions
B. Handles division by zero safely ✔
C. Formats numbers
D. Creates charts

Correct answer: B. Handles division by zero safely

38. Time intelligence functions such as TOTALYTD require:

A. A slicer
B. Only text columns
C. No dates
D. A proper date table ✔

Correct answer: D. A proper date table

39. A star schema has:

A. A central fact table connected to dimension tables ✔
B. Only dimension tables
C. Only one flat table
D. Random relationships

Correct answer: A. A central fact table connected to dimension tables

40. A fact table contains:

A. Measurable events such as sales transactions ✔
B. Only themes
C. Only descriptive attributes
D. Only images

Correct answer: A. Measurable events such as sales transactions

41. A dimension table contains:

A. Only visuals
B. Descriptive attributes such as product or customer details ✔
C. Only measures
D. Only numeric facts

Correct answer: B. Descriptive attributes such as product or customer details

42. Relationship cardinality one-to-many means:

A. No relationships
B. Only one row exists
C. Every row relates to every row
D. One row in a table relates to many rows in another ✔

Correct answer: D. One row in a table relates to many rows in another

43. Cross-filter direction controls:

A. How filters propagate between related tables ✔
B. Page order
C. Visual colours
D. Data refresh time

Correct answer: A. How filters propagate between related tables

44. Import mode in Power BI:

A. Loads data into the in-memory model ✔
B. Queries the source on every interaction
C. Cannot refresh
D. Works only with Excel

Correct answer: A. Loads data into the in-memory model

45. DirectQuery mode:

A. Queries the data source live without importing ✔
B. Copies all data
C. Only works offline
D. Cannot use filters

Correct answer: A. Queries the data source live without importing

46. Scheduled refresh in the Power BI Service:

A. Updates imported data automatically ✔
B. Changes visuals
C. Creates users
D. Deletes reports

Correct answer: A. Updates imported data automatically

47. An on-premises data gateway is needed to:

A. Write DAX
B. Refresh data from on-premises sources in the cloud service ✔
C. Create themes
D. Draw charts

Correct answer: B. Refresh data from on-premises sources in the cloud service

48. A report in Power BI is:

A. One or more pages of interactive visuals ✔
B. A single tile only
C. A dataset
D. A gateway

Correct answer: A. One or more pages of interactive visuals

49. A dashboard in Power BI is:

A. A single-page canvas of pinned tiles in the service ✔
B. A multi-page report in Desktop
C. A query
D. A dataset

Correct answer: A. A single-page canvas of pinned tiles in the service

50. A slicer is:

A. A chart type for trends
B. A visual used to filter other visuals ✔
C. A DAX function
D. A data source

Correct answer: B. A visual used to filter other visuals

Questions 51 to 75

51. Drill-down allows users to:

A. Delete data
B. Navigate from summary to more detailed levels ✔
C. Change themes
D. Export data only

Correct answer: B. Navigate from summary to more detailed levels

52. Drillthrough lets users:

A. Refresh data
B. Remove filters
C. Create measures
D. Navigate to a detail page filtered for a selected item ✔

Correct answer: D. Navigate to a detail page filtered for a selected item

53. Bookmarks capture:

A. The DAX code
B. The current state of a report page ✔
C. User passwords
D. The data source

Correct answer: B. The current state of a report page

54. Tooltips pages provide:

A. Data refresh
B. Gateways
C. Custom detail when hovering over visuals ✔
D. Row-level security

Correct answer: C. Custom detail when hovering over visuals

55. Conditional formatting in visuals:

A. Imports files
B. Deletes rows
C. Changes colours based on values or rules ✔
D. Changes data

Correct answer: C. Changes colours based on values or rules

56. A KPI visual shows:

A. Progress toward a target ✔
B. Text only
C. Maps
D. Only raw tables

Correct answer: A. Progress toward a target

57. A card visual displays:

A. A line chart
B. A table
C. A single key number ✔
D. A map

Correct answer: C. A single key number

58. A matrix visual is similar to:

A. A pivot table ✔
B. A card
C. A pie chart
D. A map

Correct answer: A. A pivot table

59. Row-level security (RLS) restricts:

A. Report themes
B. Which visuals exist
C. Refresh times
D. Which data rows users can see ✔

Correct answer: D. Which data rows users can see

60. Workspaces in the Power BI Service are used to:

A. Install Desktop
B. Store passwords
C. Write DAX
D. Collaborate and organise content ✔

Correct answer: D. Collaborate and organise content

61. A Power BI app is:

A. A gateway
B. A DAX function
C. A mobile game
D. A packaged collection of content distributed to users ✔

Correct answer: D. A packaged collection of content distributed to users

62. Power BI Pro licences allow:

A. Unlimited free premium capacity
B. Publishing and sharing content with other Pro users ✔
C. Only viewing local files
D. Database hosting

Correct answer: B. Publishing and sharing content with other Pro users

63. Q&A in Power BI lets users:

A. Change licences
B. Ask questions in natural language to create visuals ✔
C. Delete data
D. Write SQL only

Correct answer: B. Ask questions in natural language to create visuals

64. Quick Insights / Analyze features help to:

A. Import data
B. Write code
C. Create users
D. Find patterns automatically ✔

Correct answer: D. Find patterns automatically

65. Merge Queries in Power Query:

A. Joins tables based on matching columns ✔
B. Deletes columns
C. Appends rows
D. Creates visuals

Correct answer: A. Joins tables based on matching columns

66. Append Queries in Power Query:

A. Joins side by side
B. Stacks rows from multiple tables ✔
C. Filters visuals
D. Creates measures

Correct answer: B. Stacks rows from multiple tables

67. Unpivot columns transforms:

A. Rows into a single cell
B. Wide columns into attribute-value rows ✔
C. Data into charts
D. Tables into measures

Correct answer: B. Wide columns into attribute-value rows

68. Changing data types in Power Query ensures:

A. Correct calculations and sorting ✔
B. New themes
C. More users
D. Faster internet

Correct answer: A. Correct calculations and sorting

69. Removing unnecessary columns improves:

A. Visual colours
B. User count
C. Licence cost
D. Model size and performance ✔

Correct answer: D. Model size and performance

70. Query folding means:

A. Pages are hidden
B. Power Query transformations are pushed back to the data source ✔
C. Data is deleted
D. Visuals are folded

Correct answer: B. Power Query transformations are pushed back to the data source

71. Performance Analyzer shows:

A. Data lineage only
B. User activity only
C. How long visuals and queries take to load ✔
D. Licence status

Correct answer: C. How long visuals and queries take to load

72. Best practice is to prefer:

A. Calculated columns for everything
B. Measures over calculated columns for aggregations ✔
C. No relationships
D. Flat tables always

Correct answer: B. Measures over calculated columns for aggregations

73. A date table should be:

A. Random dates only
B. Continuous with no missing dates and marked as a date table ✔
C. Text only
D. Only years

Correct answer: B. Continuous with no missing dates and marked as a date table

74. Custom visuals can be imported from:

A. Windows Store only
B. Excel only
C. AppSource ✔
D. Email

Correct answer: C. AppSource

75. Themes in Power BI control:

A. Colours, fonts and visual formatting ✔
B. Licences
C. Data refresh
D. Security

Correct answer: A. Colours, fonts and visual formatting

Questions 76 to 100

76. Paginated reports are designed for:

A. Mobile games
B. Pixel-perfect printable reports ✔
C. Data cleaning
D. DAX writing

Correct answer: B. Pixel-perfect printable reports

77. Dataflows in the service allow:

A. Email alerts only
B. User management
C. Visual design only
D. Reusable Power Query transformations in the cloud ✔

Correct answer: D. Reusable Power Query transformations in the cloud

78. Data alerts on dashboard tiles notify users when:

A. A page is added
B. A value crosses a threshold ✔
C. A theme changes
D. A user logs in

Correct answer: B. A value crosses a threshold

79. Sensitivity labels help to:

A. Change chart colours
B. Speed up refresh
C. Write DAX
D. Classify and protect sensitive data ✔

Correct answer: D. Classify and protect sensitive data

80. Power BI can connect to sources such as:

A. Only Excel
B. Excel, SQL Server, SharePoint and many others ✔
C. Only text files
D. Only Access

Correct answer: B. Excel, SQL Server, SharePoint and many others

81. Calculated tables in DAX are created using:

A. Slicers
B. Visuals
C. Power Query only
D. DAX table expressions ✔

Correct answer: D. DAX table expressions

82. FILTER in DAX returns:

A. A chart
B. A single number
C. A theme
D. A table filtered by a condition ✔

Correct answer: D. A table filtered by a condition

83. COUNTROWS in DAX returns:

A. The sum of a column
B. The number of rows in a table ✔
C. A date
D. A text value

Correct answer: B. The number of rows in a table

84. DISTINCTCOUNT returns:

A. The first value
B. The number of unique values in a column ✔
C. The maximum
D. The total of values

Correct answer: B. The number of unique values in a column

85. SAMEPERIODLASTYEAR is used to:

A. Compare values with the same period in the previous year ✔
B. Delete last year’s data
C. Change fonts
D. Create a slicer

Correct answer: A. Compare values with the same period in the previous year

86. Variables in DAX (VAR) help to:

A. Import data
B. Create visuals
C. Set themes
D. Improve readability and performance of measures ✔

Correct answer: D. Improve readability and performance of measures

87. Hierarchies in Power BI enable:

A. Drill-down from year to quarter to month, for example ✔
B. Deleting levels
C. Exporting files
D. Encrypting data

Correct answer: A. Drill-down from year to quarter to month, for example

88. Sync slicers allows:

A. Changing data types
B. One slicer to filter multiple report pages ✔
C. Merging queries
D. Deleting slicers

Correct answer: B. One slicer to filter multiple report pages

89. The Selection pane manages:

A. DAX formulas
B. Data sources
C. Visibility and order of objects on a page ✔
D. User roles

Correct answer: C. Visibility and order of objects on a page

90. Export to PDF or PowerPoint is used to:

A. Create gateways
B. Share static versions of reports ✔
C. Edit data
D. Write DAX

Correct answer: B. Share static versions of reports

91. Usage metrics show:

A. How reports are being viewed ✔
B. Data refresh errors only
C. DAX syntax
D. Theme colours

Correct answer: A. How reports are being viewed

92. Power BI Embedded allows:

A. Only Excel export
B. Only printing
C. Only mobile viewing
D. Embedding reports into custom applications ✔

Correct answer: D. Embedding reports into custom applications

93. Good report design should:

A. Highlight key insights with clear, uncluttered visuals ✔
B. Avoid titles
C. Use as many visuals as possible
D. Use random colours

Correct answer: A. Highlight key insights with clear, uncluttered visuals

94. The Analyze in Excel feature lets users:

A. Explore a Power BI dataset using Excel pivot tables ✔
B. Delete datasets
C. Edit themes
D. Convert Excel to DAX

Correct answer: A. Explore a Power BI dataset using Excel pivot tables

95. Composite models allow:

A. No relationships
B. Only one table
C. Only Excel
D. Combining Import and DirectQuery sources ✔

Correct answer: D. Combining Import and DirectQuery sources

96. Incremental refresh helps to:

A. Remove security
B. Delete history
C. Refresh only new or changed data in large datasets ✔
D. Change visuals

Correct answer: C. Refresh only new or changed data in large datasets

97. The main goal of Power BI is to:

A. Store raw data only
B. Write documents
C. Replace databases
D. Turn data into interactive insights for decision-making ✔

Correct answer: D. Turn data into interactive insights for decision-making

98. Field parameters in Power BI allow users to:

A. Rename datasets
B. Delete fields
C. Encrypt data
D. Switch the measures or dimensions shown in a visual ✔

Correct answer: D. Switch the measures or dimensions shown in a visual

99. The Fields pane lists:

A. Licences
B. Report pages only
C. User roles
D. Tables, columns and measures in the model ✔

Correct answer: D. Tables, columns and measures in the model

100. A waterfall chart shows:

A. How an initial value is affected by positive and negative changes ✔
B. Text only
C. Correlation
D. Geographic data

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

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.

About Priya Dogra

Priya Dogra runs priyadogra.com, where she shares free certification courses, internships, jobs, scholarships and exam preparation guides for Indian students and freshers. Follow her on YouTube, LinkedIn and Instagram for the latest opportunities.

Check Also

Unix/ Linux Certification exam answers 2026

Unix/ Linux Certification Exam Answers 2026 (All 100 Questions)

All 100 Unix/ Linux Certification exam questions with correct answers highlighted - updated 2026.

Leave a Reply

Your email address will not be published. Required fields are marked *