Forum

Forums
Power BI
Q&A
Power BI Interview ...
 
Share:
Notifications
Clear all

Power BI Interview Questions Asked in Deloitte, EY & PwC (Real-World Scenarios, 2025 Edition)

 
Q&A
Last Post by SQL Admin 4 months ago
1 Posts
1 Users
0 Reactions
263 Views
RSS
Posts: 134
 SQL Admin
Admin
Topic starter
Nov 09, 2025 5:35 am
(@sql-admin)
Reputable Member
Joined: 6 years ago

If you’re preparing for Power BI interviews in Deloitte, EY, or PwC, you’ve come to the right place. These real-world scenario-based questions were asked in actual interviews conducted in 2025 for data analyst, BI developer, and visualization consultant roles.

This guide covers DAX formulas, Power Query transformations, data modeling, and visualization-based questions that test your hands-on project knowledge — not just theory.

🔹 Top Power BI Interview Questions & Answers (2025 Edition)

1️⃣ What are the different types of filters in Power BI?

Answer: Power BI provides four types of filters:

  • Visual-level filters

  • Page-level filters

  • Report-level filters

  • Drill-through filters
    Each helps limit data scope dynamically for better report performance.

2️⃣ How do you handle performance issues in a Power BI report?

Answer:

  • Reduce unnecessary visuals.

  • Use star schema instead of snowflake models.

  • Aggregate data at the source.

  • Use Performance Analyzer to detect bottlenecks.

  • Disable unnecessary relationships and Auto Date/Time.

✅ Commonly asked in EY & Deloitte technical rounds.

3️⃣ Explain the difference between calculated columns and measures.

Answer:

  • Calculated Column is stored in the model and increases file size.

  • Measure is calculated on the fly and is more efficient.
    Example:

 
SalesAmount = SUM(Sales[Amount])
Profit% = DIVIDE([Profit], [SalesAmount])

👉 Always use measures for performance and scalability.

4️⃣ What are common Power Query transformations used in ETL?

Answer:

  • Removing duplicates

  • Merging and appending queries

  • Changing data types

  • Using conditional columns

  • Pivot and unpivot transformations

These are crucial when dealing with data cleaning before loading into Power BI.

5️⃣ How do you implement row-level security (RLS) in Power BI?

Answer:
RLS restricts data access based on roles or users.
Steps:

  1. Define roles in Modeling → Manage Roles.

  2. Use DAX filters, e.g.:

     
    [Region] = USERPRINCIPALNAME()

  3. Publish to Power BI Service and assign users to roles.

✅ This is a frequent question in Deloitte data governance interviews.

6️⃣ How do you create a dynamic title in Power BI?

Use a measure with DAX and bind it to a text box:

 
Title = "Sales Report for " & SELECTEDVALUE(Region[Name])

It automatically updates when a slicer is selected.

7️⃣ What’s the difference between DirectQuery and Import mode?

ModeDescriptionWhen to Use
ImportData stored in Power BI cacheBest for smaller datasets
DirectQueryQueries the source in real-timeBest for large databases or real-time dashboards

EY often asks this question for Azure SQL + Power BI integration.

8️⃣ How can you optimize DAX calculations?

  • Avoid iterators like SUMX unless necessary.

  • Replace IF with SWITCH for multiple conditions.

  • Use variables (VAR) to reduce repeated computation.

  • Apply CALCULATE() carefully to modify filter context.

9️⃣ Explain the difference between ALL(), ALLEXCEPT(), and REMOVEFILTERS().

These functions modify the filter context:

  • ALL() removes all filters.

  • ALLEXCEPT() removes all filters except specified columns.

  • REMOVEFILTERS() newer function, similar to ALL but more explicit.

🔟 Real-Time Scenario Question (Asked in PwC)

Scenario: You have a dashboard showing revenue by region and product. Management wants a “What-If” parameter to simulate price increase.
Answer:

  1. Use Modeling → New Parameter → What-If Parameter.

  2. Create a measure:

     
    Adjusted Revenue = [Total Revenue] * (1 + 'Price Parameter'[Parameter Value])

  3. Add a slicer for interactive testing.

💡 Pro Tip:

Always explain why you use a specific DAX or modeling technique during the interview. Big 4 companies focus on problem-solving logic, data accuracy, and business insights clarity.

🧩 Conclusion

These Power BI interview questions from Deloitte, EY, and PwC (2025) are designed to test your end-to-end understanding — from data modeling to storytelling with visuals.
Keep practicing DAX and Power Query daily, and remember: recruiters look for clarity, optimization skills, and business understanding, not just tool knowledge.


Topic Tags
Power BI Interview Questi Deloitte Power BI Interv EY Power BI DAX Question PwC Power BI Scenarios Power BI Real-World Ques

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
Topic Tags:  Power BI Interview Questi (1) , Deloitte Power BI Interv (2) , EY Power BI DAX Question (1) , PwC Power BI Scenarios (1) , Power BI Real-World Ques (1) ,
Share: