πWhat Power BI Interviews Test
Power BI interviews for data analyst and BI developer roles move through four areas: getting data in with Power Query, modelling it well, writing DAX, and publishing and securing reports in the Power BI Service. Most rounds end with a scenario where you design a report or fix a slow one. Short DAX examples below show the patterns interviewers expect.
If you are choosing between tools, first read Power BI vs Tableau. For the wider data analyst round, see data analyst interview questions.
πPower Query and Data Preparation
1. What is Power Query?
The data preparation engine inside Power BI and Excel. It connects to sources, cleans and shapes data with recorded steps, and replays those steps on every refresh. The steps are written in the M language.2. What is query folding?
When Power Query translates your steps into the source's own language, usually SQL, so the database does the work. Folding keeps refreshes fast. Steps such as adding an index column or some custom functions can break folding, so put them as late as possible.3. Merge versus 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, for example monthly files into one table.4. How do you handle data from many monthly Excel files?
Use the Folder connector, combine files with a sample-file transform, and clean once. New files dropped in the folder are picked up on the next refresh.πData Modelling
5. What is a star schema and why does Power BI prefer it?
A central fact table with numeric events (sales lines) joined to dimension tables (date, product, customer, store). Power BI's engine compresses and filters star schemas efficiently, and DAX stays simple because filters flow from dimensions to facts.6. Explain relationship cardinality.
One to many is the normal case: one product, many sales rows. One to one is rare and often means the tables should be merged. Many to many needs care, usually solved with a bridge table.7. What is cross filter direction?
It controls which way filters flow along a relationship. Single direction (dimension to fact) is the safe default. Both directions can solve some problems but cause ambiguity and slow models, so use it sparingly.8. Why do you need a date table?
Time intelligence functions need a continuous date table marked as a date table. It also lets you slice by year, quarter, month and fiscal periods consistently.9. Active versus inactive relationships?
Only one relationship between two tables can be active. Others are inactive and used inside a measure with USERELATIONSHIP, for example order date versus ship date.πDAX Fundamentals
10. Measure versus calculated column?
A calculated column is computed per row at refresh and stored in the model, which costs memory. A measure is computed at query time in the current filter context. Use measures for totals, ratios and KPIs.11. What is row context and filter context?
Row context means "the current row", which exists in calculated columns and iterators like SUMX. Filter context is the set of filters applied by slicers, visuals and CALCULATE. Most DAX bugs come from mixing these up.12. What does CALCULATE do?
It evaluates an expression after changing the filter context. It is the core of DAX.Sales South = CALCULATE ( [Total Sales], Store[Region] = "South" )13. What is context transition?
When CALCULATE is used inside a row context, it turns the current row into an equivalent filter context. That is why a measure referenced inside a calculated column returns a per-row result.14. SUM versus SUMX?
SUM adds one column. SUMX iterates a table and evaluates an expression per row before summing, needed when you multiply columns.Revenue = SUMX ( Sales, Sales[Qty] * Sales[Unit Price] )15. What do ALL and REMOVEFILTERS do?
They remove filters from a table or column. They are used for share-of-total calculations.Sales % of Total = DIVIDE ( [Total Sales], CALCULATE ( [Total Sales], REMOVEFILTERS ( Product ) ) )16. Why use DIVIDE instead of the division operator?
DIVIDE handles division by zero gracefully and returns blank or a chosen alternate result instead of an error.17. What are variables in DAX?
VAR stores an intermediate result once and reuses it, making measures faster and easier to read.Growth % =VAR Curr = [Total Sales]VAR Prev = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )RETURN DIVIDE ( Curr - Prev, Prev )πTime Intelligence
18. How do you calculate year to date sales?
Sales YTD = TOTALYTD ( [Total Sales], 'Date'[Date] )For a fiscal year ending in March, as many Indian companies use, add the year-end date argument: TOTALYTD ( [Total Sales], 'Date'[Date], "31/3" ).
19. Previous month and month over month change?
Use DATEADD ( 'Date'[Date], -1, MONTH ) inside CALCULATE for last month, then compare with the current value using DIVIDE.20. How do you build a rolling 3 month average?
Use DATESINPERIOD to get the last three months from the latest date in context and average the monthly totals with AVERAGEX over the months.πSecurity and the Power BI Service
21. What is row level security?
Roles with DAX filters that restrict rows per user. Dynamic RLS uses USERPRINCIPALNAME() matched against a mapping table, so each manager sees only their region without one role per region.22. Power BI Desktop, Service and Mobile?
Desktop is where you build models and reports. The Service is the cloud platform where you publish, share, schedule refreshes and manage workspaces and apps. Mobile is for viewing.23. What is a gateway?
The on-premises data gateway connects the Power BI Service to data inside a company network, such as an on-site SQL Server, so scheduled refresh works.24. Import, DirectQuery and live connection?
Import loads data into the model for the fastest visuals, refreshed on schedule. DirectQuery leaves data in the source and queries it each time, used for very large or near real-time data. A live connection points to an existing published semantic model.25. What is incremental refresh?
A policy that refreshes only recent data, such as the last few days, instead of the whole table, which keeps refreshes of large fact tables fast.πPerformance
26. A report is slow. How do you fix it?
Open Performance Analyzer to find slow visuals, then check the model: remove unused columns, reduce high-cardinality columns, use a star schema, prefer measures over calculated columns, and simplify heavy DAX iterators. Reduce the number of visuals per page.27. What is DAX Studio used for?
An external tool to run and time DAX queries, view server timings and inspect model size, which helps find the real bottleneck.πScenario Questions
28. Design a sales dashboard for a retail chain.
Start with the audience and questions. Put KPIs at the top (sales, margin, growth versus last year), a trend line by month, a breakdown by region and category, and a table of top and bottom stores. Add slicers for date, region and category, and RLS so regional managers see their own stores.29. Numbers in your report do not match finance. What do you do?
Compare definitions first (gross versus net, order date versus invoice date, returns, tax). Reconcile a single month at row level, document the agreed definition, and build the measure to match it.30. How do you show the top 5 products with the rest grouped as Others?
Rank products with RANKX in a measure, or use a TOPN visual filter, and create an "Others" bucket with a disconnected table and a measure that sums everything outside the top five.πHow to Practise Before the Interview
Rebuild one complete report from raw files: load and clean it in Power Query, model it as a star schema with a proper date table, write measures for totals, growth, year to date and share of total, add dynamic RLS, and publish it to a workspace with a scheduled refresh. Then open Performance Analyzer and make the slowest visual faster. Being able to talk through each of those steps with your own example is worth more than memorising definitions, because interviewers almost always follow up with "show me how you did it".
πFAQ
Is PL-300 certification needed for Power BI jobs?
Not required, but the Microsoft PL-300 exam is a recognised signal for freshers and career switchers. Projects you can demo matter more in interviews.How much DAX should a fresher know?
CALCULATE, SUMX, filter functions, DIVIDE, variables and basic time intelligence cover most fresher interviews.Can I learn Power BI without coding?
Yes. Power Query is mostly point and click, and DAX is formula based like Excel. SQL helps a lot, so pair them.πLearn It Live
Prakalpana's Power BI course is taught live online with an optional 1-on-1 track: Power Query, modelling, DAX, RLS and the Power BI Service, with real dashboard projects and mock interviews. See the full data analytics path, then WhatsApp or call +91 9180377502 for a free demo.