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.
What should you do?
A. From the Data tab, click Refresh All
B. From the Power Pivot tab, click Update All
C. Close and open the workbook
D. Select a cell in the worksheet and press F5
If your Excel workbook has a connection to a table or query in a SQL Server database, you can make sure it shows the most up to date information. Use the Refresh command (on the Data tab) to do this.
https://support.office.com/en-us/article/refresh-a-sql-server-data-connection-3e29f331-e4b9-4120-ae46-339ca65585be
Correct Answer is A.
To get most recent and current data you need to select Refresh All.
For C (Close and open the workbook) refresh depends if you have Data Queries & Connections for that Data Model properties set to Refresh When Opening File. Another way to refresh is auto refresh, but that depends on time interval and that isn’t a answer selection here.
Answer B and D are not relevant.
The correct answer is C.
In my opinion, correct is A.
Microsoft Azure SQL will give us live data, I guess Closing and opening also works to have latest data.
Not how it works in workbook, but in PowerBI you actually need to click on Refresh all to bring the new values. At least that is how my dashboard work if I don’t set auto 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-1524175f-777a-48fc-8fc7-c8514b984440