These power bi interview questions and answers cover freshers to advanced analysts — DAX, Power Query, data modeling, the star schema, relationships and filter context — each with a concise, correct model answer you can adapt when demoing a report in the interview.
Beginner power bi interview questions
Q: What is Power BI and what are its main components?
A: Power BI is Microsoft’s business intelligence platform for connecting to data, modeling it and building interactive reports. Its main parts are Power BI Desktop for authoring, the Power BI Service for sharing and collaboration in the cloud, and Power BI Mobile for viewing. Behind these sit Power Query for data prep and DAX for calculations.
Q: What is the difference between a calculated column and a measure?
A: A calculated column is computed row by row and stored in the model, using memory and evaluated in row context. A measure is calculated on the fly at query time in filter context, responding to slicers and visuals. Use columns for row-level attributes and measures for aggregations like totals and ratios.
Q: What is DAX?
A: DAX, Data Analysis Expressions, is the formula language for Power BI, Analysis Services and Power Pivot. It provides functions for aggregation, filtering, time intelligence and logic, and is used to build measures and calculated columns. Its power comes from context-aware evaluation rather than simple cell references.
Q: What is Power Query used for?
A: Power Query is the data preparation engine where you connect to sources and clean data — removing columns, filtering rows, changing types, merging and appending queries and unpivoting. Its steps are recorded in the M language and run before data loads into the model, so transformations happen upstream of DAX.
Q: When should you transform data in Power Query versus DAX?
A: Do shaping and cleaning — type changes, filtering, merging and creating static columns — in Power Query so it happens once at refresh. Use DAX for calculations that must respond to user interaction, like measures and dynamic ratios. The rule of thumb is transform upstream in Power Query, calculate dynamically in DAX.
Q: What is the difference between Import and DirectQuery mode?
A: Import mode loads a copy of the data into Power BI’s in-memory engine, giving fast performance but requiring scheduled refreshes. DirectQuery keeps data at the source and sends queries live, so data is current and large datasets need no import, but performance depends on the source and some DAX is restricted.
Intermediate power bi interview questions
Q: What is a star schema and why is it preferred?
A: A star schema has a central fact table of numeric events surrounded by dimension tables of descriptive attributes. Power BI’s engine is optimised for it because relationships are simple and filters propagate cleanly from dimensions to facts. It performs better and produces clearer DAX than a heavily normalised snowflake model.
Q: What is the difference between a fact table and a dimension table?
A: A fact table stores measurable, numeric events such as sales amount or quantity, usually with many rows and foreign keys. A dimension table stores descriptive context such as product, customer or date, with fewer rows. Facts are aggregated; dimensions are used to slice and filter those aggregations.
Q: What does CALCULATE do?
A: CALCULATE evaluates an expression in a modified filter context. It is the most important DAX function because it can add, remove or override filters, turning a basic aggregation into a context-specific one. For example, it can compute sales for a single region regardless of the current visual filter.
Sales North =
CALCULATE( SUM( Sales[Amount] ),
Region[Name] = "North" )Q: What is the difference between SUM and SUMX?
A: SUM aggregates a single column directly. SUMX is an iterator that evaluates an expression for each row of a table and then sums the results, so it can multiply or combine columns row by row. Use SUMX for calculations like quantity times price that do not exist as a single stored column.
Q: What are the relationship cardinalities in Power BI?
A: The types are one-to-many, the most common, linking a dimension key to many fact rows; one-to-one, for split tables; and many-to-many, which needs care because filter direction can become ambiguous. Cross-filter direction can be single or both, and single is preferred to keep filter behaviour predictable.
Q: What is a slicer and how does it differ from a filter?
A: A slicer is an on-canvas visual that lets report users filter data interactively by clicking values. A filter in the Filters pane is configured by the author and can apply at the visual, page or report level. Both narrow data, but slicers are user-facing while pane filters are set during design.
Advanced power bi interview questions
Q: Explain row context versus filter context.
A: Row context is the current row during a calculated column or an iterator like SUMX, giving access to that row’s values. Filter context is the set of filters applied by slicers, rows, columns and CALCULATE that restricts the data a measure sees. Measures work in filter context; iterators create row context inside it.
Q: What is context transition?
A: Context transition happens when CALCULATE, or a measure that implicitly wraps CALCULATE, converts the current row context into an equivalent filter context. This is why calling a measure inside an iterator filters the model by the current row’s values. Misunderstanding it is a common source of unexpected DAX results.
Q: How do you create a year-to-date measure?
A: Use a time-intelligence function with a proper date table marked as a date table.
Sales YTD =
TOTALYTD( SUM( Sales[Amount] ), 'Date'[Date] )A dedicated continuous date dimension is required for time-intelligence functions to work correctly.
Q: What is the difference between ALL and REMOVEFILTERS?
A: Both clear filters from a table or column, and REMOVEFILTERS is the newer, clearer name for that purpose. ALL additionally returns the underlying table of values, so it can be used as a table argument, for instance to compute a percentage of grand total. Choose based on whether you need a table returned or only filter removal.
Q: What are calculation groups used for?
A: Calculation groups let you define reusable logic, such as time-intelligence variants or currency conversion, once and apply it across many measures instead of rewriting each. They reduce measure sprawl and are created in external tools like Tabular Editor. They are valued in larger models for maintainability.
Q: What is a bidirectional relationship and when is it risky?
A: A bidirectional relationship lets filters flow both ways across a relationship. It is useful for certain many-to-many scenarios and slicer setups, but it can create ambiguous filter paths, circular dependencies and slower performance. Best practice is to keep single-direction relationships and enable bidirectional only for a specific, tested need.
Q: How do you optimise a slow Power BI report?
A: Prefer a clean star schema, reduce cardinality, remove unused columns and use Import mode where possible. Replace calculated columns with measures when appropriate, avoid complex DAX in visuals with many rows, and limit visuals per page. Tools like Performance Analyzer and DAX Studio help locate the slow queries.
How to prepare for a Power BI interview
Build two or three end-to-end dashboards you can demo, and be ready to explain your data model, relationships and filter context out loud. Practise ten to fifteen common DAX measures and know when to use Power Query versus DAX. Analyst roles often pair BI with querying, so review our SQL interview questions too. Freshers can find entry routes in the apprenticeship and Skill India guide and current openings on the GetJobsNews homepage.
Frequently Asked Questions
How do I prepare for a Power BI interview?
Master data modeling with a star schema, the difference between calculated columns and measures, core DAX functions like CALCULATE and SUMX, Power Query transformations and relationship types. Build two or three sample dashboards you can demo and explain. Interviewers value people who can model clean data and explain filter context clearly.
Is Power BI hard to learn?
Power BI is beginner-friendly for building visuals, but DAX and data modeling take real practice. The tricky part is understanding row context versus filter context and how CALCULATE changes them. Most analysts become interview-ready in a few weeks by modeling real datasets rather than only dragging fields onto a canvas.
What Power BI topics are asked most for freshers?
Freshers face the difference between a calculated column and a measure, what DAX is, Power Query versus DAX, relationship cardinality, and how to import versus DirectQuery. Expect a scenario question on building a simple sales dashboard and a basic DAX measure such as total sales or year-to-date.
Do I need to know DAX for a Power BI interview?
Yes. DAX is central to Power BI, and interviews test CALCULATE, filter context, SUMX and time-intelligence functions. You do not need every function, but you must explain how CALCULATE modifies filters and when to use an iterator like SUMX. Practising ten to fifteen common measures covers most questions.
