Ness Digital Engineering Power BI Developer Interview Questions, Process, and Tips

DAX is a formula language used in Power BI. It has different types of functions including table DAX functions.

• DAX stands for Data Analysis Expressions

• DAX functions can be categorized into different types such as aggregation, time intelligence, filter, etc.

• Table DAX functions are used to manipulate tables in Power BI

• Examples of table DAX functions include FILTER, SUMMARIZE, ADDCOLUMNS, etc.

Power BI supports multiple connectivity modes for data sources.

• DirectQuery mode allows real-time data access from the source system.

• Import mode imports data into Power BI for faster performance.

• Live Connection mode connects to an external Analysis Services model.

• Power BI Gateway enables on-premises data access.

• Power BI Dataflows allows data preparation and transformation in the cloud.

Role based security can be created in SSAS by defining roles and assigning permissions to them.

• Create roles in SSAS and define permissions for each role

• Assign users or groups to each role

• Use Windows authentication or custom authentication to manage access to roles

• Test the security model thoroughly to ensure it is working as expected

min, minA, minX, max, maxA, maxX are functions in Power BI used to calculate minimum and maximum values.

• min: Returns the smallest value in a column or expression.

• minA: Returns the smallest non-null value in a column or expression.

• minX: Returns the smallest value in a column or expression, considering a specified filter context.

• max: Returns the largest value in a column or expression.

• maxA: Returns the largest non-null v...read more