Power BI interview questions most commonly test DAX measures, relationship cardinality, incremental refresh and running totals. Interviewers use live scenarios, not theory. Mastering these four areas, along with Power Query basics and the star schema model, is the fastest path to clearing a Power BI analyst interview in India or globally.
DAX stands for Data Analysis Expressions. It is the formula language built into Power BI, Analysis Services and Power Pivot. You use it to write measures (dynamic calculations that respond to filter context) and calculated columns (static values computed row by row at refresh time).
The single biggest mistake beginners make is treating DAX like Excel. In Excel, a formula lives in a cell with a fixed position. In DAX, every measure re-evaluates inside whatever filter context the visual creates. That shift in mental model is what separates people who struggle from people who get hired in Power BI interview questions rounds.
Measures are stored as expressions, not data. They calculate at query time, which makes them memory-efficient. Calculated columns are computed once at refresh and stored in the model, consuming RAM. For large datasets, overusing calculated columns inflates file size quickly.
| Feature | Measures | Calculated Columns |
|---|---|---|
| Storage | Expression only, no data stored | Stored in model, consumes RAM |
| Evaluation time | At query time (dynamic) | At refresh time (static) |
| Use case | KPIs, aggregations, time intelligence | Row-level categorisation, flags |
| Performance impact | Low memory, higher CPU at query | Higher memory, lower query CPU |
| Filter context aware | Yes | No |
A simple sales measure looks like this: Total Sales = SUM(Sales[Revenue]). A harder one uses CALCULATE to override filter context: Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Dates[Date])). That second formula is what most interviewers use to test whether you understand evaluation context in Power BI DAX interview questions.
A running total, also called a cumulative sum, is one of the most common DAX interview tasks. The standard pattern uses CALCULATE with FILTER and ALL:
Running Total = CALCULATE([Total Sales], FILTER(ALL(Dates[Date]), Dates[Date] <= MAX(Dates[Date])))
This works because ALL removes the existing date filter, then FILTER reapplies it as everything up to and including the current date in context. Without ALL, the measure returns the same value as Total Sales for every row. Interviewers know this trap well and use it specifically in Power BI interview questions to test context transition knowledge.
Group By appears in Power Query (M language), not DAX. You use it to aggregate rows during data transformation, before the data hits the model. In Power Query’s UI, click Transform, then Group By, choose your grouping column and pick an aggregation like Sum or Count. It is equivalent to a SQL GROUP BY clause. Knowing where Group By lives is itself a test question in many Power BI interview questions sets.
When measures return unexpected results, DAX Studio is the tool professionals use. It is a free, open-source desktop application you connect to your Power BI Desktop file. You can run DAX queries directly, see query plans and measure execution time in milliseconds. The DAX Studio download is available at daxstudio.org. Indian data teams at companies like Infosys, Wipro and TCS list DAX Studio proficiency in job descriptions for senior BI roles.
Cardinality in Power BI describes the uniqueness of values in a relationship column. Power BI supports three types: one-to-many (1:*), one-to-one (1:1) and many-to-many (*:*). One-to-many is the standard: a single row in the dimension table matches multiple rows in the fact table.
Many-to-many relationships are where analysts get into trouble. Before Power BI composite models were introduced in 2018, many-to-many required a bridge table. Now you can set it directly, but without understanding filter propagation, your totals double-count or under-count without any error message appearing. This is a high-frequency topic in Power BI cardinality interview questions.
Each relationship has a cross-filter direction: Single or Both. Single means filters flow from the one side to the many side. Both allows bidirectional filtering, which sounds convenient but creates ambiguous filter paths in complex models. Microsoft’s official documentation recommends avoiding Both direction unless you have a specific reason. Most BI architects in India’s consulting sector follow that rule strictly.
High-cardinality columns, such as transaction IDs or email addresses, compress poorly in Power BI’s VertiPaq engine. According to SQLBI’s VertiPaq Analyzer benchmark research (published at sqlbi.com), a column with 10 million unique values can consume 4 to 6 times more memory than a column with 10,000 unique values. That is why data modellers normalise aggressively and avoid pulling high-cardinality columns into visuals unless necessary.
| Relationship Type | When to Use | Risk Level | Filter Direction |
|---|---|---|---|
| One-to-Many (1:*) | Standard dimension-to-fact joins | Low | Single (recommended) |
| One-to-One (1:1) | Split tables for performance | Low | Single or Both |
| Many-to-Many (*:*) | Role-playing dimensions, shared dimensions | High | Both (use carefully) |
Incremental refresh in Power BI tells the service to load only rows added or changed after a defined date, rather than re-importing the entire dataset every time. For a table with 50 million rows, this can cut a 90-minute refresh down to under 5 minutes.
You configure it using two reserved Power Query parameters: RangeStart and RangeEnd, both of type Date/Time. Power BI uses these parameters to partition the data into historical (archived) and recent (refreshable) ranges. Historical partitions are never touched again after the first load. Only the recent partition refreshes on each scheduled run.
Incremental refresh requires a Power BI Premium or Premium Per User licence. It will not work on Pro licences for the full feature set, though basic range filtering is available. The source data must support query folding, meaning the filter on RangeStart and RangeEnd must be pushed back to the source database as a native query. If query folding breaks, Power BI pulls the entire table and filters it in memory, defeating the purpose entirely.
According to Microsoft’s Power BI documentation (docs.microsoft.com, updated 2023), datasets using incremental refresh with query folding show up to 80% reduction in refresh duration compared to full-table imports. That figure is why enterprise clients in banking and e-commerce in India, including analytics teams at HDFC Bank and Flipkart, prioritise this feature in their BI architecture. Microsoft’s 2024 Power Platform report also confirms that Power BI is used by over 250,000 organisations globally, with certified analyst demand growing sharply on LinkedIn and Naukri in India.
A practical Power BI roadmap for Indian professionals follows this sequence: start with Power Query and data transformation, then learn the star schema data model, then DAX fundamentals (SUM, CALCULATE, FILTER, ALL, time intelligence), then advanced DAX patterns like running totals and dynamic segmentation, then report design and performance optimisation, and finally incremental refresh and deployment pipelines.
Microsoft’s PL-300 certification (Power BI Data Analyst Associate) maps almost exactly to that sequence. It is the most recognised Power BI credential for Indian job applications, with exam fees around Rs. 4,800 as of 2024. If you want to understand how Power BI fits into a broader data career, read our guide on how to become a data scientist and our breakdown of top data science tools companies are actually using.
For interview prep beyond Power BI, our data analyst interview questions guide covers SQL, statistics and communication skills that hiring managers test alongside technical BI knowledge. If you are thinking longer term, the scope of data science in India gives you a realistic picture of where the market is heading.
Career switchers should look at our article on shifting from data science to AI and machine learning, since many BI analysts use Power BI as their entry point before moving into ML engineering roles. For course options that pay off fast, check our list of top online courses for high-salary jobs in 2025 and the broader best career options in 2026 for students and working professionals.
Common Power BI interview questions include: explain the difference between a measure and a calculated column; what is CALCULATE and when do you use it; how do you handle many-to-many relationships; write a running total measure; what is query folding; and how does incremental refresh work. Senior roles also ask about row-level security, deployment pipelines and model performance optimisation.
DAX (Data Analysis Expressions) is the formula language used in Power BI to create measures and calculated columns. It evaluates inside filter context, which makes it fundamentally different from Excel. You use DAX for time intelligence calculations, running totals, dynamic rankings and any metric that needs to respond to slicer or visual selections in a report.
Cardinality describes how many rows in one table match rows in another. Power BI supports one-to-many, one-to-one and many-to-many relationships. One-to-many is the standard pattern for star schema models. Many-to-many is valid but risky: without careful filter direction settings, it produces double-counted totals with no error message to warn you something is wrong.
Yes, the full incremental refresh feature in Power BI requires a Premium or Premium Per User licence. Pro licences support basic date range filtering but not true partitioned incremental refresh. The data source must also support query folding so that date filters are pushed to the source system rather than applied in memory after a full table import.
Write a DAX measure using CALCULATE, FILTER and ALL: Running Total = CALCULATE([Total Sales], FILTER(ALL(Dates[Date]), Dates[Date] <= MAX(Dates[Date]))). The ALL function removes the existing date filter context, and FILTER reapplies it as a cumulative range. Without ALL, the measure simply returns the same period value rather than accumulating across dates.
The most tested DAX functions in Power BI interview questions are CALCULATE, FILTER, ALL, ALLEXCEPT, SUMX, RELATED, SAMEPERIODLASTYEAR and RANKX. Interviewers focus on CALCULATE because it controls filter context, which is the core concept that separates intermediate from advanced DAX users. Time intelligence functions like SAMEPERIODLASTYEAR and DATESYTD are also standard in senior-level rounds.
The practical next steps this week: download Power BI Desktop (free), connect it to a sample dataset from Kaggle, build a star schema with at least one date table, write three measures using CALCULATE, and configure a relationship with explicit cardinality settings. Then install DAX Studio, run your measures through it and read the query plan. That single hands-on session teaches more than hours of passive reading about Power BI interview questions.
If you want structured, mentor-guided learning that goes beyond self-study, 3.0 University offers online certification courses in AI, Cybersecurity, Ethical Hacking, Blockchain and Web3, designed specifically for students, working professionals and career switchers in India. The curriculum is built around practical, industry-ready skills, not just theory. Explore the full course catalogue at 3.0 University and find the programme that matches where you want to go.
Last updated: September 2026. Reviewed by the 3University editorial team.
We create, review, and maintain educational content covering Cybersecurity, Ethical Hacking, Artificial Intelligence, Blockchain, Web3, and emerging technologies.
The Government of India has launched YUVA AI for ALL a 100% free AI certificate course under the IndiaAI Mission (MeitY). This 4.5-hour, self-paced online
Quick answer: The highest paid profession in India is medicine senior surgeons and anaesthesiologists can earn ₹1–3 crore a year. CEOs, investment bankers, AI/ML engineers
Quick answer: There is no rigid eligibility for cyber security course admission in most online programs. If you have completed 10+2 (any stream) or hold
Cybersecurity has become one of the fastest-growing career fields in India and across the world. As cyber threats continue to increase, organizations are actively hiring
Choosing between the OSCP and the CEH is one of the biggest decisions in any ethical hacker career. Both are respected, both open doors but
A penetration test is only as valuable as the report that follows it. While identifying vulnerabilities is a critical part of the assessment process, the
Not a member yet? Register now
Are you a member? Login now
Not a member yet? Register now
Are you a member? Login now
