Power BI MCQs

1. What is Power BI primarily used for?

2. Which company develops and maintains Power BI?

3. Which file extension is used for a Power BI Desktop report file?

4. Which file extension is used for a Power BI template file?

5. Which three components make up the core Power BI suite?

6. What does the acronym “BI” stand for in Power BI?

7. Which of the following is Power BI's free desktop authoring tool for building reports?

8. Which Power BI component lets users view and interact with reports on smartphones and tablets?

9. What is the main difference between a Power BI “Report” and a “Dashboard”?

10. Which of the following best describes a Power BI “Workspace”?

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

12. Which Power BI Desktop view displays the raw rows of a loaded table?

13. Which pane in Power BI Desktop lists all the tables and columns available for building visuals?

14. Which pane lets you choose a visual type and drag fields into wells such as Axis, Legend, and Values?

15. Which ribbon tab contains the “Get Data” button used to connect to a new data source?

16. Which Power BI Desktop view is used to create and manage relationships between tables?

17. Which button switches Power BI Desktop into “Reading view” so viewers cannot accidentally edit a report?

18. Which feature captures the current state of a report page, including filters and visual selections, so it can be recalled later?

19. Which pane lets you show or hide individual visuals and objects on a report page, useful for layered designs?

20. Which Power BI Desktop feature applies transformation steps performed in the Power Query Editor to update the data model?

21. What is the most common cardinality used in a relationship between a fact table and a dimension table?

22. In a star schema, which type of table typically stores descriptive attributes such as customer name or product category?

23. What does “cross filter direction” control in a Power BI relationship?

24. Which data modeling approach organizes data into a central fact table connected to surrounding dimension tables?

25. Compared to a star schema, a snowflake schema typically involves what trade-off?

26. Which feature lets you create a new table in the model using a DAX expression instead of importing data?

27. Which dialog in Power BI Desktop allows you to view, create, edit, or delete relationships between tables?

28. What is a “bridge table” commonly used for in data modeling?

29. Which term describes the number of unique values on each side of a relationship (for example, one-to-many)?

30. What is the recommended best practice for date-based analysis and time intelligence in a Power BI model?

31. What is Power Query in Power BI primarily used for?

32. Which pane in the Power Query Editor lists each transformation step you have applied, in order?

33. Which Power Query feature stacks rows from two or more tables with matching columns into a single table?

34. Which Power Query feature combines two tables by joining them on matching key columns?

35. Which language underlies all Power Query transformation steps behind the scenes?

36. Which Power Query action converts column headers and their values into rows of attribute-value pairs?

37. What does “Query Folding” mean in Power Query?

38. Which button loads the transformed data from the Power Query Editor into the Power BI data model?

39. Which Power Query feature automatically detects and assigns appropriate data types to imported columns?

40. Which Power Query tool provides column-level statistics such as error, empty, and distinct value counts for data quality checks?

41. What does the acronym DAX stand for?

42. Which DAX construct is stored per row and increases the size of the model, similar to an Excel formula copied down a column?

43. Which DAX construct is calculated on the fly based on the current filter context and is not stored in the model?

44. Which DAX function adds up the values in a numeric column?

45. What does the DAX function RELATED() do?

46. What is “row context” in DAX?

47. What is “filter context” in DAX?

48. Which DAX function returns the number of rows in a table or a filtered table expression?

49. Which DAX function returns today's date?

50. Which DAX function returns a custom value in place of an error, similar to Excel's IFERROR?

51. Which DAX function is used to modify the filter context of an expression, enabling calculations like conditional totals?

52. Which DAX time-intelligence function returns values from the same period one year earlier?

53. Which DAX function computes a year-to-date total directly, without needing to be wrapped in CALCULATE()?

54. Which DAX function is the modern, explicit way to clear all filters from a table or column?

55. Which DAX function is an iterator that evaluates an expression row by row and then sums the results?

56. Which DAX keyword lets you store an intermediate calculation to improve formula readability and performance?

57. Which DAX function returns the rank of a value within a specified list of values?

58. Which DAX function preserves existing filters instead of overwriting them when used inside CALCULATE()?

59. Which DAX function activates a relationship that has been marked as inactive in the data model, for use within a specific calculation?

60. Which DAX function returns a table containing every combination of rows from two tables, useful for what-if style analysis?

61. Which visual type is best suited for showing a trend over a continuous period, such as monthly revenue?

62. Which visual type displays hierarchical, part-to-whole data as nested, proportionally sized rectangles?

63. Which feature lets a user right-click a data point in one visual and open a separate, detail-focused report page filtered to that value?

64. Which built-in visual is designed to track a metric's progress against a target, showing status through color and trend?

65. When you select a data point in one visual, other visuals on the same report page highlighting related data is called what?

66. Which visual type combines columns and a line to compare two measures with different scales on the same chart?

67. Where can users find and import custom visuals that are not built into Power BI by default?

68. Which feature automatically adjusts a report's layout so it displays well on a smartphone screen?

69. Which chart type is most appropriate for illustrating the cumulative effect of sequential positive and negative values, such as a profit bridge?

70. Which feature displays additional contextual details, such as a mini chart, when a user hovers over a data point?

71. Which action uploads a report built in Power BI Desktop to the Power BI Service?

72. What is a “Workspace” used for in the Power BI Service?

73. Which component securely connects on-premises data sources to the Power BI Service for scheduled refresh?

74. What does the modern term “semantic model” refer to in the Power BI Service?

75. Which Power BI license type provides organization-wide capacity so that viewers do not each need an individual Pro license?

76. What does Power BI Premium Per User (PPU) provide?

77. Which feature packages a curated set of related dashboards, reports, and datasets for easy distribution to a group of users?

78. Which Power BI Service feature lets administrators monitor tenant-wide usage, adoption, and performance?

79. Which feature allows an organization to mark a dataset or report as officially trusted and high quality?

80. Which Power BI Service feature refreshes data from a source on a recurring, automated schedule?

81. What is a “tile” on a Power BI dashboard?

82. Which feature lets users type a plain-language question and have Power BI automatically generate a matching visual?

83. Which feature automatically notifies a user by email when a dashboard metric crosses a threshold they define?

84. What does “Subscribe” to a report or dashboard do in the Power BI Service?

85. Which Power BI capability allows developers to embed interactive reports and dashboards into custom applications or websites?

86. Which feature lets colleagues leave notes directly on a dashboard tile or report visual to discuss the data?

87. If a report lives outside Premium capacity, what does a colleague generally need to view it if they don't have Pro?

88. Which Microsoft collaboration app allows Power BI reports and dashboards to be pinned directly into a channel for team visibility?

89. Which feature groups multiple related datasets, reports, and dashboards so that end users can navigate them from a single, organized location?

90. Which Power BI Service feature makes it possible to view a report offline for a short period after it has last been synced on mobile?

91. What is the primary purpose of Row-Level Security (RLS) in Power BI?

92. Where in Power BI Desktop do you define RLS roles and their filter rules?

93. Which DAX function is commonly used to implement dynamic RLS based on the currently logged-in user?

94. After publishing a report that includes RLS roles, what must an admin do in the Power BI Service to enforce it for specific people?

95. What does Object-Level Security (OLS) restrict, in contrast to RLS?

96. Which governance feature helps organizations classify and protect sensitive data in Power BI, often integrating with Microsoft Purview?

97. Which feature shows how a dataset, dataflow, or report is connected to other items across a workspace, aiding governance and impact analysis?

98. What is a “shared dataset” (certified dataset) used for from a governance perspective?

99. Which tenant-level setting, managed by an admin, can restrict whether users are allowed to export underlying data from reports?

100. What is a key limitation to be aware of when relying on RLS for security?

101. What is the main purpose of Copilot in Power BI?

102. Which built-in AI visual automatically identifies the key drivers behind changes in a metric?

103. Which AI visual lets users interactively break down a metric across multiple dimensions, in any order, to explore root causes?

104. Which feature automatically generates a written, natural-language summary describing the key takeaways in a report or visual?

105. Which Power BI AI capability flags unusual spikes or dips within a time-series visual automatically?

106. Which type of licensing or capacity is generally required to unlock full Copilot capabilities in Power BI?

107. When a user right-clicks a data point and selects “Analyze,” what does Power BI's AI typically do?

108. Which AI-powered feature suggests possible groupings of similar data points based on underlying patterns, without a manual formula?

109. Besides generating visuals, which of the following is a task Power BI Copilot can help with directly in Power BI Desktop?

110. What is one commonly cited benefit of using AI-powered analysis features in Power BI?

111. Which built-in Power BI Desktop tool measures how long each visual on a report page takes to load?

112. Which storage mode loads all data into memory, generally giving the fastest query performance for visuals?

113. Which storage mode sends queries directly to the source system each time a visual refreshes, without importing the data?

114. Which modeling approach combines Import mode and DirectQuery for different tables within the same Power BI model?

115. Which in-memory, columnar storage engine powers Power BI's fast aggregations and compression?

116. Which setting, when disabled, can reduce model size and improve performance by preventing Power BI from auto-generating hidden date hierarchies?

117. Which practice helps reduce a model's size and improve performance by lowering the number of unique values in high-cardinality columns?

118. Which technique refreshes only new or changed data in a large fact table instead of reloading the entire table each time?

119. Which external, widely used tool is commonly paired with Power BI to write, tune, and analyze DAX queries in greater depth?

120. Which feature in Power BI Desktop lets you capture and review the queries sent to a data source, in order to diagnose slow refreshes?