After defining a data source view (DSV) in an Analysis Services project or database, the schema in an underlying data source may change.



For more information about setting up the AMO programming environment, how to establish a connection with a server, accessing a database or defining data sources and data source views, see can be processed using its own process method, or it can be processed with the parent object's process method when the parent object is processed.
During refresh, Analysis Services queries all underlying relational data sources to determine whether there have been changes in tables/views which are included in the DSV.
If connections can be established to all underlying data sources and there have been any changes, you will see them in the Refresh Data Source View dialog box.
Note that additional work is often required to further update the cubes and dimensions in the project that use the DSV.
This topic includes the following sections: Changes Supported in Refresh Refresh a DSV in SQL Server Data Tools DSV Refresh can include any of the following the actions: To refresh a DSV, double-click the DSV from Solution Explorer in SQL Server Data Tools (SSDT). Then click the Refresh Data Source View button in the designer or choose Refresh from the Data Source View menu.