Analyzing and Visualizing Data with Microsoft Excel — Question 84

Your company has a data analyst who uses Microsoft Power BI Desktop to create a data model and several reports.
The data analyst publishes the reports to the Power BI service.
You need to create a PivotTable in Excel that uses the data model created by the data analyst. The solution must prevent the data from being imported into Excel.
What should you do first?

Answer options

• A. From Excel, create a new query that uses the Data Catalog
• B. From powerbi.com, select the report. From the File menu, click Download report
• C. From powerbi.com, select the report and click Analyze in Excel
• D. From powerbi.com, select the report. From the File menu, click Save us

Correct answer: C

Explanation

The correct answer is C because selecting 'Analyze in Excel' allows you to connect to the Power BI data model without importing the data into Excel, enabling a live connection. The other options either do not facilitate a live connection (A, B, D) or require data import, which contradicts the requirement.