See how to:
(01:45) Update Calendar Table in Excel file when we anticipate new transactional data with new dates.
(03:35) Update Existing Connections to Source Data Files when File Name or File Path has changed.
(04:17) Refresh Data Model with new data and new columns from Source Access File and new dates from Calendar table in Excel file. Refresh Data Model
(05:36) Use Table Properties to allow new column in fact table (new column comes from original data source).
(06:16) Reports automatically update!