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

microsoft-exams

7 thoughts on “What should you do?

  1. 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.

    1. Microsoft Azure SQL will give us live data, I guess Closing and opening also works to have latest data.

      1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.