Quess Power BI Developer Interview Questions, Process, and Tips

SUM calculates the total of a column, while SUMX evaluates an expression for each row in a table and returns the sum of the results.

• SUM is used to calculate the total of a column in a table.

• SUMX is used to iterate over each row in a table, evaluate an expression, and return the sum of the results.

• SUMX is commonly used in DAX formulas to perform calculations row by row.

A gateway in Power BI is a bridge that connects on-premises data sources to the cloud service.

• There are two types of gateways in Power BI: On-premises data gateway and Personal gateway.

• On-premises data gateway is used to connect cloud services to on-premises data sources.

• Personal gateway is used for individual users to refresh data within Power BI.

• Gateways ensure secure data transfer between on-premises and cloud envir

Row level security is a feature in Power BI that restricts access to data at the row level based on user roles or criteria.

• Row level security allows you to control which rows of data a user can see in a report or dashboard.

• It is commonly used to ensure that users only see the data that is relevant to them based on their role or department.

• Row level security can be implemented using DAX expressions to filter data based ...read more