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…

The correct answer is B. From the data tab, click Refresh All. Refresh data from a Microsoft Query, the Data Connection Wizard, or web query Click any cell in the range or table that contains the link to the external data. On the Data tab, in the Connections group, click Refresh All. To update only the selected data, click Refresh. You can…

Consume and transform data by using Microsoft Excel

Question

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?

Options

ASelect a cell in the worksheet and pressF5.
BFrom the data tab, click Refresh All.
CClose and open the workbook.
DFrom the Power Pivot tab, click Update All.

How the community answered

(24 responses)

A
4% (1)
B
75% (18)
C
4% (1)
D
17% (4)

Explanation

Refresh data from a Microsoft Query, the Data Connection Wizard, or web query Click any cell in the range or table that contains the link to the external data. On the Data tab, in the Connections group, click Refresh All. To update only the selected data, click Refresh. You can also right-click a cell in the range or table, and then click Refresh. To update all the data connections in the workbook, click Refresh All. Note: If you have more than one workbook open, you'll need to repeat the operation in each workbook. https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-for- windows-1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-CA&ad=CA

Topics

#data refresh#Azure SQL Database#Refresh All#workbook queries

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice