Implementing Analytics Solutions Using Microsoft Fabric — Question 189

You have a Microsoft Power BI semantic model.

You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.

What should you use?

Answer options

• A. Performance Analyzer in Power BI Desktop
• B. Model explorer in Microsoft Power BI Desktop
• C. Model view in Microsoft Power BI Desktop
• D. DAX Formatter in DAX Studio

Correct answer: B

Explanation

The Model explorer in Microsoft Power BI Desktop is specifically designed to provide an overview of the model's structure, including properties like Summarize By, making it the most efficient option for this task. The Performance Analyzer focuses on measuring performance metrics, while the Model view and DAX Formatter do not directly address identifying surrogate keys with specific properties.