109 questions in 10 topics
Power BI Interview Questions for Freshers
What Power BI is, its parts, how a report gets from raw data to the Service, and the first terms every round checks.
- What is Power BI?
- What are the building blocks of Power BI?
- What is the difference between Power BI Desktop and the Power BI Service?
- What is the difference between a report and a dashboard?
Power BI Data Modeling Interview Questions
Star schemas, relationships, cardinality, filter direction, date tables and the modeling mistakes that break totals.
- What is a star schema, and why does Power BI work best with one?
- What is the difference between a fact table and a dimension table?
- What relationship cardinalities does Power BI support?
- What is cross filter direction, and when would you set it to Both?
DAX Interview Questions and Answers
Measures and calculated columns, row and filter context, aggregators and iterators, BLANK, and the everyday DAX functions.
- What is DAX?
- What is the difference between a measure and a calculated column?
- What is the difference between row context and filter context?
- What is the difference between SUM and SUMX?
CALCULATE and Filter Context Interview Questions
CALCULATE, context transition, the ALL family, KEEPFILTERS, Boolean filters versus FILTER, and the totals that do not add up.
- What does CALCULATE do, step by step?
- What is context transition?
- What is the difference between ALL, ALLEXCEPT, ALLSELECTED and REMOVEFILTERS?
- How do you write a percent of total measure?
Power BI Time Intelligence Interview Questions
Year to date, same period last year, growth, rolling windows, fiscal years and the date table they all depend on.
- What do DAX time intelligence functions need to work?
- How do you calculate year to date sales?
- How do you show the same period last year?
- How do you write year over year growth as a percentage?
Power Query Interview Questions
Shaping data before it loads: applied steps, merges and appends, the M language, query folding, parameters and incremental refresh.
- What is Power Query?
- What is the difference between Merge and Append?
- Which Power Query transformations do you use most?
- When would you unpivot columns?
Power BI Report and Visualization Interview Questions
Drill down and drillthrough, interactions, bookmarks, tooltips, conditional formatting, parameters and readable report design.
- What is the difference between drill down and drillthrough?
- How do you stop one visual from filtering another?
- What are bookmarks used for?
- How do you build a report page tooltip?
Power BI Service, Sharing and Security Interview Questions
Workspaces and roles, apps and sharing, gateways and refresh, row-level security and deployment pipelines.
- What are the workspace roles in the Power BI Service?
- What are the ways to share a Power BI report?
- What is the difference between a workspace and an app?
- What is an on-premises data gateway, and when do you need one?
Power BI Performance Interview Questions
Finding and fixing slow reports: the VertiPaq engine, model size, Performance Analyzer, DAX Studio, DirectQuery and aggregations.
- How does the VertiPaq engine store data?
- How do you make a Power BI model smaller?
- How do you find which visual makes a page slow?
- What do the Server Timings in DAX Studio tell you?
Power BI Scenario Based Interview Questions
Problems you solve out loud: totals that do not match, slicers that do not filter, budget versus actual, new customers and dynamic security.
- Your report total does not match the source system. How do you find out why?
- A measure shows the same number on every row of a table. What is wrong?
- A slicer does not filter one of the visuals. What do you check?
- Users say a report is slow. Walk me through what you do.
Frequently Asked Questions
How do I prepare for a Power BI interview?
Build one small report end to end: import two or three tables, model them as a star with a date table, write measures with CALCULATE, year to date and a percent of total, and publish it. Then answer the questions on these pages out loud. Expect to explain your choices: why a measure and not a column, why Import and not DirectQuery.
What do freshers and experienced candidates get asked?
Freshers get the basics: Desktop versus the Service, report versus dashboard, measures versus calculated columns, relationships, the common visuals and simple DAX. With 3 to 5 years expect filter context, CALCULATE, time intelligence, row-level security and Power Query. Senior rounds add performance tuning, data modeling choices and scenarios solved on the spot.
Is DAX hard to learn?
The functions are easy; the evaluation context is what takes time. Once you can say which filters apply to a cell of a visual, and what CALCULATE changes about them, most measures follow. Practice on a small model where you can check each result by hand.
Do I need SQL for a Power BI role?
Usually, yes. Many reports read from SQL databases, and you will write views or queries to shape data before it reaches Power BI, and debug a total by querying the source. Joins, GROUP BY and window functions are enough for most analyst roles. See the SQL interview questions.
Can I practice DAX without Power BI Desktop?
Yes. Power BI Desktop runs only on Windows, but Coddy's Power BI course runs a Power BI workspace in the browser on any computer, and checks every measure you write against the lesson's data.