Analyzing and Visualizing Data with Microsoft Excel — Question 1

You have an Excel spreadsheet that contains a PivotChart.
You install Microsoft Power BI Publisher for Excel.
You need to add a tile for the PivotChart to a Power BI dashboard.
What should you do?

Answer options

• A. From powerbi.com, click Get apps
• B. From powerbi.com, upload the Excel workbook
• C. From the File menu in Excel, click Publish
• D. From the Power BI tab in Excel, click Pin

Correct answer: C

Explanation

The correct answer is C, as using the 'Publish' option from the File menu in Excel allows you to send the PivotChart directly to Power BI. Option A is incorrect because 'Get apps' does not pertain to publishing content. Option B is not the right choice since uploading the workbook doesn't specifically pin the PivotChart to a dashboard. Option D is misleading since it does not specify the correct method for adding the tile to the dashboard.