DXC Technology Power BI Developer Interview Questions and Answers

There are multiple types of filters in Power BI including visual, page, report, and drill-through filters.

• Visual filters apply to a specific visual or group of visuals.

• Page filters apply to all visuals on a specific page.

• Report filters apply to all visuals on all pages of a report.

• Drill-through filters allow users to navigate to a different report page based on a selected data point.

The three filters can be applied to the data in Power BI to narrow down the results.

• Filters can be applied to specific columns or measures in the data

• Filters can be used to show only certain values or ranges of values

• Filters can be combined to create more complex filtering logic

There are three connectivity modes in Power BI: Import, DirectQuery, and Live Connection.

• Import mode: Data is imported into Power BI and stored in a dataset.

• DirectQuery mode: Data stays in the data source and queries are sent directly to the source.

• Live Connection mode: Power BI connects directly to the data source for real-time data access.

Power BI components include Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

• Power Query: Used for data extraction and transformation.

• Power Pivot: Used for data modeling and analysis.

• Power View: Used for interactive data visualization.

• Power Map: Used for geographical data visualization.

• Power Q&A: Allows users to ask questions in natural language and get answers from data.

DAX stands for Data Analysis Expressions and is a formula language used in Power BI for creating custom calculations.

• DAX is used to create custom calculations in Power BI, similar to Excel formulas.

• It can be used to create calculated columns, measures, and calculated tables.

• DAX functions can be used to manipulate data, perform calculations, and create complex expressions.

• Examples of DAX functions include SUM, AVERAGE,

M language is a powerful data transformation language used in Power Query in Power BI.

• M language is used to transform and clean data in Power BI.

• It is a functional language with a wide range of functions and operators.

• M language is case-sensitive and uses a step-by-step approach to data transformation.

• Examples of M language functions include Table.TransformColumns and List.Transform.

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.

• Power Query is a data transformation tool in Power BI used to import, transform, and clean data before loading it into the data model.

• It allows users to connect to various data sources such as Excel, databases, web services, and more.

• Users can perform data cleansing, transformatio...read more

summarize is used to aggregate data at a specified level, while summarizetable is used to aggregate data across multiple tables.

• summarize is used with a single table, while summarizetable can be used with multiple tables

• summarize can only be used with columns from the specified table, while summarizetable can be used with columns from multiple tables

• summarize can be used to create new columns, while summarizetable is u

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