1.whawhat are the challenges faced in your project? 2.what is difference between active & inactive relationship & explain detailed with 1 example? 3.what is star schama & snow flake schema & give example? 4.how many joins in power bi & what are they? 5.what is cross join? 6.what is append query?& Merge query? Give me a example? 7.why required reports & dashboard?8.how to remove duplicate in power bi?

Question

Accepted Answer

Key concepts and challenges in Power BI development, including relationships, schemas, joins, and data manipulation techniques.

Challenges in projects may include data quality issues, performance optimization, and user adoption.
Active relationships are used in calculations, while inactive relationships can be activated using DAX functions like USERELATIONSHIP.
Star schema has a central fact table connected to dimension tables, while snowflake schema normalizes dimension tables into multiple related tables.
Power BI supports various joins: Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, and Cross Join.
Cross join produces a Cartesian product of two tables, combining every row from the first table with every row from the second.
Append queries combine rows from two or more tables, while merge queries combine columns from two tables based on a related column.
Reports provide detailed insights, while dashboards offer a high-level overview; both are essential for data-driven decision-making.
To remove duplicates in Power BI, use the 'Remove Duplicates' option in the Power Query Editor.

Accepted Answer

Soln for 2 qsn :Active relationship is denoted by
solid dash line
inactive by dotted line 
inactive relationship is greyed and 
to make inactive to active we need to use 
userelatioship dax function

WNS Power BI Developer interview questions & answers

Popular interview questions of Power BI Developer