Log in to Jobaaj

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Power BI MCQ With Answers

40 practice questions · Last updated on Aug 25, 2026

Q&A guide Share:

Power BI interviews focus on modelling and DAX, because those determine whether a report is correct and fast. Expect questions on Power Query versus the data model versus DAX, why a star schema matters, the difference between calculated columns and measures, filter context and what CALCULATE does, Import versus DirectQuery, relationship cardinality and cross-filter direction, and row-level security. Report performance and incremental refresh come up regularly. The questions below cover the full stack.

Power BI MCQ

1.Which Power BI layer is responsible for extracting and transforming data before it enters the model?

2.What is the key difference between a calculated column and a measure?

3.Why is calculating a profit margin as a calculated column and then summing it wrong?

4.What is a star schema?

5.Why is a dedicated Date table marked as a date table essential?

6.Which DAX function is the only one that can modify filter context?

7.What is filter context in DAX?

8.Which DAX pattern correctly calculates percentage of total?

9.Why should DIVIDE be preferred over the division operator in DAX?

10.Which storage mode loads data into memory and gives the best query performance?

11.What is a significant drawback of DirectQuery mode?

12.What is the default cross-filter direction for a one-to-many relationship?

13.Why are bidirectional relationships generally discouraged?

14.How many active relationships can exist between two tables?

15.Which tool in Power BI Desktop shows how long each visual takes to render and query?

16.Which column type typically consumes the most memory in a Power BI model?

17.What is the most effective first step when optimising a slow Power BI report?

18.Why does having many visuals on one report page slow it down?

19.What does row-level security in Power BI restrict?

20.Which DAX function is used for dynamic row-level security based on the signed-in user?

21.Which users bypass row-level security entirely?

22.What is the difference between a Power BI workspace and an app?

23.What is the difference between a Power BI report and a dashboard?

24.What is required to refresh a dataset connected to an on-premises SQL Server?

25.What does incremental refresh do?

26.Which requirement is essential for incremental refresh to actually improve performance?

27.How many scheduled refreshes per day are allowed on shared capacity?

28.What does the VAR keyword provide in a DAX measure?

29.What is row context in DAX?

31.What does the ALL function do inside CALCULATE?

32.Which visual is most appropriate for comparing a single value against a target?

33.What is a slicer used for in a Power BI report?

34.Which Power BI feature lets a user jump from a summary visual to a detailed page filtered to the selected item?

35.What does the Q&A visual allow?

36.Why should measure definitions be documented for report users?

37.What is the most common reason a published report shows different numbers from a user's spreadsheet?

38.Which practice most improves user trust in a dashboard?

39.Which tool provides detailed analysis of a Power BI model's memory usage by column?

All trademarks are the property of their respective owners

All rights reserved @ 2026 Nishtya Infotech (India) Ltd.

Log in to Jobaaj

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as

Jobseeker
Employer