Updating imported data in excel
When you save the current set of table properties, you will get a message – Please wait.Then the number of rows retrieved will be displayed.
You can manually refresh your data any time, if you need to update the data from an existing data source or get the recent data for designing new DAX formulas.
DAX enables data modeling and reporting activities to be handled in an effective way.
However, this requires updating the data in the Data Model from time to time so as to reflect the current data.
In my last post Auto refresh pivottables data in excel on first run, i found that on my first execution the query from the External data source is refreshed and takes approximately 1 min to execute.
and in my second run, the pivot tables are updated.