Skip to content
CompanyBenchCompanyBench

Power BI interview questions and answers

Power BI interview questions with clear answers on DAX, data modelling, Power Query, bookmarks, slicers, reports vs dashboards and report performance.

Questions on DAX, data modelling, Power Query, dashboards and performance tuning, with concise answers. Level: intermediate to advanced. For pay benchmarks, see the Power BI developer salary guide.

Frequently asked questions

What is Power BI and how is it used for data visualisation?

Power BI is Microsoft's business analytics tool. You use it to connect to many data sources, build interactive reports and dashboards, and share insights.

What is DAX and how is it used in Power BI?

DAX (Data Analysis Expressions) is the formula language for calculated columns, measures and calculated tables.

What is data modelling in Power BI?

Structuring data with relationships, hierarchies and keys so you can analyse across several tables at once.

What is Power Query and how does it help with data transformation?

Power Query is the tool for connecting to and transforming data. It uses the M language to clean, reshape and load data before it reaches the model.

How do you optimise performance in Power BI reports?

Use summarised tables, cut the number of visuals, apply filters carefully and avoid bi-directional relationships. Use Performance Analyzer to find what is slow.

What are bookmarks and how are they used in Power BI?

A bookmark saves the current state of a report page, including filters, slicers and visuals. Use them for guided navigation, storytelling or custom views.

What is the difference between a slicer and a filter in Power BI?

A slicer is a visual on the page that users click to filter the report. A filter is set in the Filters pane and can apply at visual, page or report level.

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

A report is a multi-page set of visuals built on one dataset. A dashboard is a single page of tiles that can be pinned from several reports, along with images.

Explain the difference between CALCULATE and FILTER in DAX.

CALCULATE changes the filter context and can apply several filters at once. FILTER returns a table you can pass as a filter argument, but it is often slower for simple conditions.

What is the difference between SUMX and SUM in DAX?

SUM adds up the values in a column. SUMX is an iterator: it evaluates an expression for each row and then sums the results, which makes it the right choice for row-by-row calculations.