EXL Service Power BI Developer Interview Questions and Answers

Joins are used to combine data from two or more tables based on a related column.

• Inner Join: Returns only the matching rows from both tables.

• Left Join: Returns all the rows from the left table and matching rows from the right table.

• Right Join: Returns all the rows from the right table and matching rows from the left table.

• Full Outer Join: Returns all the rows from both tables, with NULL values in the columns where ther...read more

Power BI supports three types of relationships: one-to-one, one-to-many, and many-to-many.

• One-to-one: used when two tables have a unique relationship, such as a person and their social security number.

• One-to-many: used when one record in the first table can have multiple matching records in the second table, such as a customer and their orders.

• Many-to-many: used when multiple records in the first table can have multipl...read more