Posted by: Pdfprep
Post Date: January 10, 2021
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.
Answer: B
Explanation:
Refresh data from a Microsoft Query, the Data Connection Wizard, or web query
Leave a Reply