Why should you do?

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.

You discover that new rows were added to the tables in Azure SQL Database.

You need to ensure that the workbook has the new data.

Why should you do?
A . Select a cell in the worksheet and pressF5.
B . From the data tab, click Refresh All.
C . Close and open the workbook.
D . From the Power Pivot tab, click Update All.

View Answer

Answer: B

Explanation:

Refresh data from a Microsoft Query, the Data Connection Wizard, or web query