✅ Power BI Interview Questions 🎯📊

1️⃣ What is Power BI?
A Microsoft tool for data visualization, reporting, and business intelligence.

2️⃣ What are the building blocks of Power BI?
• Datasets
• Reports
• Dashboards
• Tiles
• Visualizations

3️⃣ Difference between Power BI Desktop and Power BI Service?
• Desktop: Used to create and design reports
• Service: Cloud-based platform to share and collaborate

4️⃣ What is Power Query?
A data transformation tool for cleaning and shaping data before loading into the model.

5️⃣ What is DAX?
Data Analysis Expressions – a formula language used for calculations in Power BI.

6️⃣ What are measures and calculated columns?
• Measure: Calculated on aggregation (e.g. SUM of sales)
• Calculated Column: Row-level computation (e.g. profit = revenue - cost)

7️⃣ What is a slicer?
A visual filter that allows users to dynamically filter data on a report.

8️⃣ How do you handle data refresh in Power BI?
• Schedule refresh via Power BI Service
• Use gateways for on-prem data sources

9️⃣ What is the difference between direct query and import mode?
• Import: Data is loaded into Power BI
• Direct Query: Queries run directly on the source in real time

🔟 What is the Power BI Gateway?
A bridge between on-premise data sources and Power BI cloud service.

💬 Tap ❤️ for more