Common Power BI Interview Questions Power Query Editor (built-in ETL) 1. What you done your project and what is your roles & responsibilities? 2. What are the transformations used in your project? 3. What are the different sources you have used in your project? 4. What is difference between Import Mode and Direct Query? 5. What is Fact table and Dimension table? 6. Difference between Star Schema and Snowflake Schema? 7. What is Merge and Append in power query editor? 8. What are the building blocks of Power BI? 9. What is Query Folding in Power Query? 10. What is Power BI Q&A? 11. What are the components of Power BI? 12. What is Conditional Formatting in Power BI? 13. How do you handle errors in Power Query? 14. Three processes to replace replaces null values? 15. Difference between referencing and duplicating a query in Power Query. 16. What is the M language, and how does it relate to Power Query? 17. How do you schedule data refreshes in Power Query? 18. What are custom columns in Power Query, and how do you create them? 19. What is the 'Group By' function in Power Query, and how is it used? 20. Explain how to remove duplicates from a dataset in Power Query. Power View / Power BI Desktop 1. What are the charts you have used in your project? 2. Any Custom Charts have you used? 3. What is difference between Filters and Slicers? 4. What is Bookmarks in Power BI? 5. How can you make your reports dynamic? 6. Types of relationship in Power BI? 7. What are Drillthrough and Drilldown in Power BI? 8. How do you optimize the performance of a Power BI report? 9. How do you handle large datasets in Power BI Desktop? 10. Difference between Tile vs Report vs Dashboard ? 11. Difference between Drill down vs Drill Through? DAX 1. What is difference between Measures and Calculated Column? 2. What are DAX functions you have used in your project? 3. What is difference between SUM and SUMX? 4. What is use case of SUMMARIZE function? 5. What is ALL and ALLEXCEPT function? 6. What is the need of Data Master Table? 7. Can you explain use case of SAMEPERIODLASTYEAR? 8. What is Row Context in DAX? 9. What do you mean by MTD , QTD & YTD? 10. Difference between Sum vs SumX? Power BI Services 1. Which Power BI License you have used in your project? 2. What is Difference between MyWorkspace and Workspace? 3. What are the roles available in workspace? 4. What is RLS? 5. What is Gateway? How many types? 6. Difference between Report and Dashboard? 7. How can you refresh data in Power BI? 8. Explain the concept of Scheduled Refresh and Incremental Refresh? 9. What is Dataflow? 10. How do you share Power BI reports with external users? 11. How do you schedule automatic data refresh in Power BI Service? 12. Types of roles in Power BI Service? 13. How do you set up incremental refresh in Power BI Service? Power BI Resources 👇👇 https://t.me/PowerBI_analyst Hope you'll like it Like this post if you need more content like this 👍❤️