Power BI interviews for freshers usually test whether you understand the three layers (Power Query, the model, DAX) rather than every menu option. Here are the questions you should be ready for.
General
What are the main components of Power BI?
Power BI Desktop (to build reports), the Power BI Service (to publish and share online), and Power BI Mobile. Inside Desktop: Power Query for data preparation, the model view for relationships, DAX for calculations and the report canvas for visuals.
Import vs DirectQuery
Import loads a copy of the data into the file: fast, but needs refreshing. DirectQuery queries the source each time: always current, but slower and with some limits. Import is the common default.
Power Query
What is Power Query used for?
Cleaning and shaping data before it reaches the model: removing rows, fixing types, splitting columns, merging and appending tables, unpivoting. Each step is recorded and replays on refresh.
Merge vs Append
Merge joins two tables side by side on a key (like a SQL join). Append stacks tables with the same columns on top of each other (like UNION ALL).
What is unpivoting?
Turning columns into rows, for example converting Jan, Feb, Mar columns into Month and Value columns. Models and DAX work much better with this long format.
Data modelling
What is a star schema?
A central fact table (events with numbers, such as sales or claims) connected to dimension tables (descriptions, such as product, customer and date) through one-to-many relationships. It keeps the model simple and DAX predictable.
Relationship cardinality and filter direction
One-to-many is the normal case. Filters flow from the "one" side (dimension) to the "many" side (fact). Bi-directional filtering exists but should be used sparingly because it can create ambiguous results.
Why do you need a Date table?
Time intelligence functions need a continuous table of dates marked as the date table. It also gives consistent month, quarter and year columns.
DAX
Measure vs calculated column
A calculated column is computed row by row when data loads and is stored in the model. A measure is computed when a visual needs it, in the current filter context. Use measures for aggregations; use columns only when you need a value per row (for example, to slice by it).
What does CALCULATE do?
It evaluates an expression in a modified filter context. Example: CALCULATE([Total Sales], 'Product'[Category] = "Laptops"). See CALCULATE explained.
Row context vs filter context
Filter context is the set of filters applied by slicers, visuals and CALCULATE. Row context exists when DAX iterates over rows, in calculated columns and in iterator functions like SUMX.
SUM vs SUMX
SUM adds a single column. SUMX iterates over a table and adds an expression per row, for example SUMX(Sales, Sales[Qty] * Sales[Price]).
Why use DIVIDE?
DIVIDE(a, b) handles division by zero safely, returning blank (or a value you choose) instead of an error.
Name some time intelligence functions
TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, DATESYTD, PREVIOUSMONTH.
Report design
- How do you choose visuals? (Card for a single KPI, line for trends, bar for comparison, matrix for detail.)
- What are slicers and how do you sync them across pages?
- What are drill-through pages and tooltips?
- What is row-level security? (Restricting which rows each user can see, defined with DAX roles.)
Best answer: a project
Interviewers often say "walk me through a dashboard you built". Have one ready. Our motor claims Power BI project gives you a realistic brief, messy data and requirements that cover Power Query, modelling and DAX, which is exactly what you need to talk through.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: