Diggibyte Technologies Power BI Developer Interview Questions and Answers for Experienced

Import model is a Power BI feature that allows you to import data from various sources and create a data model.

• Import model is used to create a data model in Power BI.

• It allows you to import data from various sources such as Excel, CSV, SQL Server, etc.

• You can create relationships between tables, add calculated columns, and measures.

• Import model is useful when you have large amounts of data that need to be transformed ...read more

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.