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?

121. Which DAX function is commonly used to evaluate an expression under a modified filter context?

122. Which DAX function can apply a table expression as a filter to another table without requiring an active physical relationship?

123. Which DAX function is useful for returning a single value from a column when exactly one distinct value exists in the current context?

124. Which DAX function can be used to test whether exactly one distinct value is present in a column?

125. Which DAX function can determine whether a column or table is being directly filtered?

126. Which DAX function is commonly used to return the maximum value of an expression evaluated over a table?

127. Which DAX function returns a table containing the top N rows based on a specified expression?

128. What is the main purpose of a calculation group in a Power BI semantic model?

129. Which DAX concept allows a measure to behave differently depending on the current filter context?

130. Which DAX feature can dynamically change the display format of a measure based on its value or context?

131. Which Power Query feature allows you to reuse an existing query as the starting point for another query while maintaining a separate result?

132. What is the main advantage of preserving query folding for supported transformations?

133. Which Power Query operation is most appropriate for replacing values such as "N/A" with a blank or standardized value?

134. Which M function is commonly used to transform a list of values into a new list by applying a function to each item?

135. Which Power Query feature is useful for automatically applying the same transformation logic to multiple files with a consistent structure?

136. What is the purpose of the Power Query Advanced Editor?

137. Which Power Query transformation groups rows based on one or more columns and can calculate aggregations such as Sum or Count?

138. Which transformation converts values in one column into multiple columns based on unique values?

139. Which Power Query practice is generally recommended when working with very large source tables?

140. Which Power Query feature can help identify whether transformations are being pushed back to a supported data source?

141. Which Power BI tool is commonly used to inspect the DAX queries generated by report visuals and analyze their execution time?

142. Which storage engine is responsible for highly compressed, in-memory columnar data in Import mode?

143. Why can high-cardinality columns increase Power BI model size?

144. Which practice can reduce the size of an Import-mode semantic model?

145. Which feature can improve performance when a model contains a large detailed fact table but users mostly analyze aggregated results?

146. Which DAX practice can improve readability and sometimes reduce repeated evaluation of the same expression?

147. Why are measures generally preferred over calculated columns for dynamic aggregations?

148. Which Power BI feature helps identify which visuals are consuming the most time when rendering a report?

149. Which model design is generally recommended for Power BI analytical models?

150. What is a common performance risk of using bidirectional relationships unnecessarily?

151. What is the primary purpose of incremental refresh in Power BI?

152. Which Power Query parameters are commonly used when configuring incremental refresh?

153. Which scenario is the strongest candidate for incremental refresh?

154. What does partitioning achieve in a large Power BI model using incremental refresh?

155. Which feature can automatically detect and refresh only recent partitions while preserving historical data?

156. Why is query folding important when implementing incremental refresh against a relational source?

157. What is a key benefit of a hybrid table in Power BI?

158. Which requirement is especially important before implementing incremental refresh?

159. Which scenario can benefit from detecting data changes during incremental refresh?

160. Which statement best describes a large semantic model strategy?

161. What is the primary purpose of Direct Lake storage mode in Microsoft Fabric?

162. Which Microsoft Fabric storage layer is closely associated with Direct Lake?

163. Which two common Direct Lake approaches are available in Microsoft Fabric?

164. In Direct Lake on SQL, what can happen when Direct Lake cannot be used for a query?

165. Which type of data format is commonly used by Fabric lakehouse storage and can be consumed by Direct Lake?

166. Which statement best describes the difference between Import and Direct Lake?

167. Why is Direct Lake especially relevant for large Fabric analytics solutions?

168. Which Power BI feature allows developers to inspect and edit semantic model metadata using a code-oriented approach?

169. What is TMDL primarily concerned with in Power BI?

170. Which scenario is a good candidate for Direct Lake?

171. What is the primary purpose of a Power BI deployment pipeline?

172. Which environment usually represents the final stage where approved Power BI content is consumed by business users?

173. What does Row-Level Security (RLS) control in Power BI?

174. What is Object-Level Security (OLS) used for?

175. Which DAX function is commonly used in dynamic RLS to retrieve the identity of the currently signed-in user?

176. Which Power BI feature helps package reports and dashboards into a curated experience for business users?

177. Which workspace role generally provides the highest level of permissions within a Power BI workspace?

178. What is a certified semantic model intended to communicate?

179. Why are endorsement and certification useful in enterprise Power BI governance?

180. What is lineage view useful for in Power BI?

181. What is Microsoft Copilot in Power BI primarily designed to help users do?

182. What is an important prerequisite for getting useful answers from Copilot in Power BI?

183. Which Power BI experience allows Copilot to generate or explain DAX queries using natural-language prompts?

184. Why should developers validate DAX generated by Copilot?

185. Which semantic model property can improve Copilot's understanding of similarly named fields?

186. What can Copilot do in the Power BI web modeling experience?

187. What is the biggest governance concern when using generative AI with enterprise Power BI data?

188. What are Power BI agentic capabilities designed to help AI agents do?

189. Which technology can allow an AI coding agent to interact with Power BI capabilities through standardized tools?

190. Why is semantic model documentation particularly important for AI-assisted Power BI development?

191. What is a key characteristic of Power BI visual calculations?

192. Which calculation is a common use case for a Power BI visual calculation?

193. How do visual calculations differ from traditional semantic-model measures?

194. Which visual calculation is useful for smoothing short-term fluctuations in a time series?

195. Which reporting feature allows a report page to display a different visual layout for different device sizes?

196. Which feature allows users to switch dynamically between different dimensions or measures in a visual?

197. Which feature is best for allowing users to navigate between report pages using buttons?

198. What is the purpose of a report page tooltip?

199. Which Power BI feature lets users switch between predefined report states, such as showing and hiding different visual groups?

200. A company wants a Power BI solution that handles very large Fabric data, uses governed semantic models, supports AI-assisted analytics, and allows developers to manage model metadata programmatically. Which combination best fits this requirement?