Which tool is used in Power BI to provide insight into performance bottlenecks?

The tool that provides insight into performance bottlenecks in Power BI is known as the Performance Analyzer. This feature is specifically designed to help users understand how long their queries are taking to process. It allows users to record performance metrics related to visuals in their reports, enabling them to identify which elements may be causing delays or are less efficient.

When using the Performance Analyzer, users can monitor various aspects of the report, such as the time taken to retrieve data, render visuals, and load the entire report. By analyzing these metrics, users can pinpoint specific areas that need optimization to improve overall report performance. This makes it an invaluable tool for developers and data analysts to diagnose issues and enhance user experience.

The other options, while useful in their own right, serve different purposes. DAX Studio is primarily used for writing and executing DAX queries and performing analysis on data models, rather than directly analyzing performance bottlenecks. Data Profiling is focused on assessing the quality and structure of the data being used, helping to clean and prepare datasets rather than diagnose performance issues. Power Query Editor is designed for data transformation and loading, enabling users to shape their data before it’s analyzed, but not for assessing performance after the data model is built or the report is generated.