Interview Questions and Answers

Power Query is used for data transformation and shaping in Power BI. It allows you to connect to various data sources, clean and transform the data, and then load it into the Power BI data model.

A Power BI gateway cluster is a group of multiple gateway installations that work together to provide high availability and load balancing. It ensures continuous connectivity to on-premises data sources.

The 'M' language is used in Power BI's Power Query Editor for data transformation and manipulation. It is a functional language that helps define the steps to clean and shape data before loading it into the data model.

The Power BI REST API allows developers to embed Power BI reports and dashboards into custom applications. It provides programmatic access to Power BI artifacts, enabling automation and integration with other services.

In Power Query, errors can be handled using the 'try...otherwise' construct. This allows you to specify alternate values or actions when an error occurs during data transformation.

Custom visuals in Power BI can be created using the Power BI Developer Tools in Visual Studio Code. Developers can use TypeScript and the Power BI JavaScript API to build and deploy custom visuals.