Accenture Power BI Developer Interview Questions, Process, and Tips for Experienced

Cardinality refers to the uniqueness of values in a column or relationship.

• Cardinality is the number of unique values in a column or relationship.

• High cardinality means a column has many unique values, while low cardinality means few unique values.

• For example, a column like 'Customer ID' may have high cardinality, while 'Gender' may have low cardinality.

SQL query to retrieve data from a table

• Use SELECT statement to specify columns to retrieve

• Use FROM statement to specify the table to retrieve data from

• Use WHERE statement to filter the data based on conditions

Row context refers to the current row in a table during DAX calculations, allowing for row-specific evaluations.

• Row context is established when a DAX formula is evaluated for each row in a table.

• An example of a DAX function that allows row context is 'SUMX', which iterates over a table and evaluates an expression for each row.

• In 'SUMX(Table, Expression)', 'Table' provides the row context for 'Expression'.

• Another exampl...read more

RLS in Power BI restricts data access based on user roles, ensuring users see only relevant data.

• Define roles in Power BI Desktop using DAX filters to restrict data visibility.

• Example: Create a role 'Sales' with a filter like [Region] = USERNAME() to show data only for the user's region.

• Publish the report to Power BI Service and assign users to the defined roles.

• Test the roles in Power BI Desktop using the 'View as Rol

Cardinality in Power BI refers to the uniqueness of values in a column or relationship.

• Cardinality can be one-to-one, one-to-many, or many-to-many.

• It helps determine how data should be modeled and relationships should be established.

• For example, a one-to-many cardinality means one value in one table can be related to multiple values in another table.

There are three types of gateways in Power BI: On-premises data gateway, Personal gateway, and Power BI Gateway (Enterprise). Each serves a different purpose.

• On-premises data gateway is used to connect on-premises data sources to Power BI service.

• Personal gateway is used for individuals to refresh data from on-premises data sources.

• Power BI Gateway (Enterprise) is used for organizations to manage data refresh for cloud...read more