Accenture Power BI Developer Interview Questions, Process, and Tips

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

Power BI has three connection modes: Import, DirectQuery, and Live Connection.

• Import mode imports data into Power BI and creates a dataset.

• DirectQuery mode connects to the data source and queries data in real-time.

• Live Connection mode connects to a published dataset in Power BI Service.

• Import mode is best for small to medium-sized datasets, while DirectQuery and Live Connection are better for large datasets.

• DirectQuery...read more

Row level security in Power BI allows restricting data access based on user roles and filters.

• Row level security can be implemented using roles and filters in Power BI.

• Roles can be created and assigned to users or groups to restrict access to specific data.

• Filters can be applied to tables or columns to limit data visibility based on user roles.

• Row level security can be tested using the View As Roles feature in Power BI...read more