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 new data. What 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
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 new data. What 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.