✅ Top 10 Power BI Interview Questions & Answers 📊💼

1️⃣ What is Power BI and why is it used?
Power BI is Microsoft’s business analytics tool for creating interactive dashboards and reports. It helps visualize data for better decision-making.

2️⃣ Key components of Power BI?
- Power BI Desktop: For building reports
- Power BI Service: Cloud sharing & collaboration
- Power BI Mobile: Access on mobile
- Power BI Gateway: Connect on-premise data
- Power BI Report Server: On-premise reporting

3️⃣ What is DAX?
DAX (Data Analysis Expressions) is the formula language used to create custom measures, calculated columns, and tables.

4️⃣ Calculated Column vs Measure?
- Calculated Column: Row-by-row calculation, adds new column
- Measure: Aggregates data, used in visuals

5️⃣ DirectQuery vs Import Mode?
- Import: Faster, data stored in Power BI
- DirectQuery: Real-time queries, slower, connects live to DB

6️⃣ What are Relationships in Power BI?
They define how tables connect using keys, allowing cross-table filtering and data modeling.

7️⃣ How to optimize performance?
- Use Import mode
- Follow Star Schema
- Limit visuals & slicers
- Use aggregated tables
- Optimize DAX

8️⃣ What is a Slicer?
A visual filter users can interact with to filter data on the report page.

9️⃣ Handling null values?
- Use Replace Values in Power Query
- Use DAX like: IF(ISBLANK([Column]), 0, [Column])
- Use COALESCE for defaults

🔟 What are Bookmarks?
They save the report's state (filters, visuals) to create guided views or navigation buttons.

👍 React ❤️ if you found this helpful!