Top 100 Power BI Interview Questions for experienced

Question 1: What is Power BI?

Question 2: What is self-service business intelligence?

Question 3: What is Power BI Desktop?

Question 4: What are the major components in  Power BI Architecture?

Question 5: What are the main data sources can Power BI connect to?

Question 6: What are Building Blocks in Power BI?

Question 7: What are the different filters available in Power BI Reports?

Question 8: What are content packs in Power BI?

Question 9: What is query language used in Power BI?

Question 10: What is DAX?

Question 11: What is MQuery?

Question 12: How to create measure in Power BI?

Question 13: Can we created Calculated column in Power BI?

Question 14: What is slicer in  Power BI?

Question 15: What is Dataset endorsement in Power BI?

Question 16: What is Promoted and Certified dataset?

Question 17: What is dataflow in Power B?

Question 18: How to add a new capacity under Power BI Tenant?

Question 19: What is card visuals?

Question 20: What are the performance tuning techniques in Power BI reporting?

Question 21: What is a workspace in Power BI?

Question 22: What is Power BI Pro-license?

Question 23: How to choose between power BI premium workspace and Pro-License?

Question 24: What is tenant admin in Power BI?

Question 25: What are the major roles available in under Power BI Workspace settings?

Question 26: How to connect Power BI Premium capacity workspace from SQL Server Management Studio?

Question 27: How to connect Power BI Premium capacity workspace from SQL Server Data Tools?

Question 28: How to do Dimension Modelling in Power BI?

Question 29: What are the important visuals you worked with under Power BI?

Question 30: What are the most common DAX Functions used?

Question 31: How to use Variables in DAX and benefits?

Question 32: How would you create trailing X month metrics via DAX against a non-standard calendar?

Question 33: What are the Custom Visuals and How to import them in Power BI?

Question 34: What is query folding in Power Query?

Question 35: What are the data destinations for Power Queries?

Question 36: What are some common Power Query/Editor Transforms?

Question 37: What is Power Map?

Question 38: What are the primary requirement for a table to be used in Power Map?

Question 39: What types of data types are available in Power BI?

Question 40: What are the important features of Power BI dashboard?

Question 41: How to pin a report under Dashboard in Power BI?

Question 42: How to create DAX function in Power BI?

Question 43: Is there any drawbacks of using Power BI?

Question 44: What is Power BI report builder?

Question 45: What is the term responsive slicers in Power BI?

Question 46: Define the term M language?

Question 47: What are the steps to go to Data Stories Gallery in Power Bi communities?

Question 48: How to use Performance Analyzer in Power BI?

Question 49: How to implement incremental data refresh in Power  BI?

Question 50: What are the steps to implement Row Level Security?

Question 51: How can you analyze Power BI reports data in excel?

Question 52: What is Power Pivot, and what are the filter writes in Power BI?

Question 53: How can you perform Dynamic filtering in Power BI?

Question 54: Which programming language is used in Power Query?

Question 55: List out benefits of using Variables in DAX?

Question 56: What are Tiles in Power BI?

Question 57: What is Power BI Gateway?

Question 58: How to transfer data from On-Premise to Cloud?

Question 59: Name two types of connectivity modes in Power BI?

Question 60: How to create Power BI report subscription? 

Question 61: Explain the term data alerts?

Question 62: What is query collapsing?

Question 63: What is bookmark in a PowerBI report?

Question 64: Can we create drill through and drill down report in  Power BI, if yes then how?

Question 65: What are the filter types are available in Power BI?

Question 66: What is the use of selection pane in Power BI?

Question 67: How to handle Many to Many relationships in Power BI?

Question 68: Explain x-velocity in memory?

Question 69: What is Active and In-active relationship in Power BI?

Question 70: Is it possible to have created multiple active relationships in Power BI?

Question 71: State the main difference between Filter and Slicer?

Question 72: How to embed a Power BI report under Asp.Net application?

Question 73: How to setup schedule refresh of Power BI reports after they publish to cloud?

Question 74: Can we implement Machine Learning model in Power BI, if yes then how?

Question 75: How to publish a SSRS report into a Power BI workspace?

Question 76: What is the use of Q&A highlight in Power BI?

Question 77: List out some benefits of using Power BI?

Question 78: What is interactive report in Power BI?

Question 79: List out some drawbacks/limitations of using Power BI?

Question 80: Should we include SSAS cube for dimension  modeling or Power BI ?

Question 81: What are the  different connectivity modes available in Power BI?

Question 82: What are the different types of refresh options available in Power BI?

Question 83: What is difference between Power BI Dataset and Data flow?

Question 84: Can we use Power BI Data flow and Dataset as source for another Power BI report?

Question 85: Can we use Power BI Data flow and Dataset as source from any other reporting?

Question 86: Can we connect Power BI Data flow from SQL Server Data Tool, SQL Server Management Studio?

Question 87: How to apply group by clause in Power BI report?

Question 88: What is the main difference between Admin and Member roles in workspace access?

Question 89: How to download online Power BI report into your local system?

Question 90: What are the file formats are avaialble to  export a Power BI report?

Question 91: What is Power BI report server and how to setup ?

Question 92: Can we create standard Power BI report like as SSRS?

Question 93: Describe the Gather function of the Power BI process?

Question 94: How to register an Oracle source under Power BI Gateway to move data from On-Prem to Cloud?

Question 95: What is the difference between Power BI and Power Apps?

Question 96: What is Power View?

Question 97: How to analyze a Power BI report into Microsoft excel?

Question 98: What are the KPIs in Power BI? 

Question 99: What are the main differences between standard and premium capacity workspace?

Question 100: Can we create perspectives in Power BI, if yes then How?