Delete a Data Source in Solution Explorer (SSAS Multidimensional)
Applies To: SQL Server 2016
You can delete a data source object to permanently remove it from an Analysis Services multidimensional model project.
In Analysis Services, data sources provide the basis on which data source views are constructed, and data source views are in turn used to define dimensions, cubes, and mining structures in an Analysis Services project or database. Therefore, deleting a data source may invalidate other Analysis Services objects in an Analysis Services project. You should always review the list of dependent objects that is provided before deleting the object.
In SQL Server Data Tools (SSDT), open the project or connect to the database from which you want to delete a data source.
In Solution Explorer, expand the Data Sources folder.
Right-click the data source, and then click Delete. The Delete Objects dialog box appears, showing the objects that will be invalidated if you delete the data source. Review this list carefully before clicking OK to delete the data source.
Save the project.
After deleting a data source from an Analysis Services project, you must save the modified project or you will receive an error the next time you open the project because the underlying XML file for the deleted data source will be missing when the project attempts to load the deleted data source.