Power BI Interview Questions and Answers

Power BI Interview Questions and Answers

Covers Calculated Columns, Measures, Power Query, Data Gateway & Parameters :-

• Question 01 :- What are Calculated columns ?

• Question 02 :- Where can calculated columns be created in Power BI?

• Question 03 :- What are calculated measures in Power BI?

• Question 04 :- Where can calculated measures be created in Power BI?

• Question 05 :- Difference between Calculated Column and Measure in Power BI?

• Question 06 :- What are M codes in power bi & Where Can You Write Power Query M Code?

• Question 07 :- What are Parameters in Power BI?

• Question 08 :- What is Power BI data gateway?

• Question 09 :- Do we need data gateway for schedule refresh in Power BI?

• Question 10 :- What is Query Folding in Power BI?

• Question 11 :- What is the use of Split function in Power BI?

• Question 12 :- Difference between visual level, page level and report level filters in Power BI?

Questions on ALL & ALL EXCEPT functions, Grouping , what if parameter, Distinct :-

• Question 13:- Difference between ALL and ALL EXCEPT functions?

• Question 14:- What is "What if" parameter in Power BI?

• Question 15:- How to keep or remove specific rows in Power BI?

• Question 16: What is grouping in power bi and how to use it?

• Question 17:- Difference between Distinct and Values in Power BI?

Important questions on DAX, DAX Function, Power Query, Power BI Reports :-

• Question 18:-What is DAX and most common DAX functions used?

• Question 19:- What is Power Query?

• Question 20:- What are different types of Filters in Power BI Reports?

Differentiating between sum vs sumx and Direct Query vs Import Query :-

• Question 21 :- Difference between sum and sumx in power bi?

• Question 22 :- Import Query vs Direct Query in power bi?

Append Query vs Merge Query and different types of Power BI Joins :-

• Question 23 - Append Query VS Merge Query in Power BI ?

• Question 24 - Types of Join and Types of Join kind in Power BI ?

LookupValue DAX function, Differentiate Datesbeteween VS  DatesinPeriod in Power BI.

• Question 25 - What is LookupValue DAX function in Power BI ?

• Question 26- Understand Datesbetween vs DatesinPeriod ?

Crack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.

• Question 27 - COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTINCTCOUNT, COUNTROWS ?

• Question 28 - How to filter Top N in Power BI ?

Difference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.

• Question 29 :- Power BI USERELATIONSHIP VS TREATAS ?

• Question 30:- What is Bookmark in Power BI?

Power BI Interview Questions and Answers

Url: View Details

What you will learn

• Understand what kind of Questions are asked in Power BI and how to answer the same.
• Covers Power BI questions around Calculated columns,Calculate measures , M Codes , Power Query, Parameters , Power BI gateway, visual level vs page level vs rep
• How to tackle Power BI Interview Questions around All vs All Except ,What IF , Grouping in power BI , Distinct vs Values.

Rating: 4.75

Level: All Levels

Duration: 4.5 hours

Instructor: QuestIT Pvt limited