Cognizant Power BI Developer Interview Questions and Answers

Gateway is a tool that allows Power BI to connect to on-premises data sources. Dataflow is a self-service data preparation tool in Power BI.

• Gateway enables Power BI to securely access on-premises data sources.

• Dataflow allows users to extract, transform, and load data from various sources into Power BI.

• Gateway and Dataflow work together to enable data refresh and data preparation in Power BI.

• Gateway can be used to connect to databases, files, and other data sources located on-...read more

Gauge charts are used to visually represent a single value within a given range.

• Gauge charts are commonly used in business dashboards to display key performance indicators (KPIs).

• They provide a quick and intuitive way to assess the current status or progress towards a goal.

• Gauge charts can be used to show metrics such as sales targets, customer satisfaction scores, or production efficiency.

• They are effective in highlighting deviations from the desired value or target.

• Gauge ch...read more

Power BI provides various types of security to protect data and control access.

• Row-level security allows restricting data access based on user roles or filters.

• Data encryption ensures that data is securely stored and transmitted.

• Azure Active Directory integration enables centralized user authentication and access control.

• Power BI service provides access and sharing controls to manage permissions.

• Data loss prevention policies help prevent accidental sharing of sensitive inform...read more

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 and modeled.

• It is also useful when you need to combine dat...read more

Incremental refresh in Power BI allows for loading only new or modified data to improve performance.

• Set up incremental refresh policy in Power BI Service

• Define a range of values for the refresh policy

• Use parameters to filter data based on the refresh policy

• Schedule regular refreshes to update the dataset