How can you update an Analysis Services tabular model with the changes in the data source?

Question

After defining a model in a SQL Server Analysis Services Tabular project, the schema in an underlying data source may change. These changes are not automatically detected or updated in a project.

With multidimensional projects you can open the DataSource View right click on "refresh" to get the updates. However, I don't see similar functionality in tabular projects.

How can you update an Analysis Services tabular model with the changes in the data source?

Answer 1

Follow these steps to update the model after the underlying database changes:

1. Right click on a table and select Table 'Properties...'
2. Click the 'Design...' button
3. Click on the 'Query' menu
4. Click 'Refresh Current'