Deleting a Data Source in Solution Explorer (Analysis Services)

Deleting a data source is permanent. You cannot restore a deleted data source to a Microsoft SQL Server Analysis Services database or 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.

Important

Data sources on which other objects depend cannot be deleted from an Analysis Services database opened by Business Intelligence Development Studio in online mode. You must delete all objects in the Analysis Services database that depend on that data source before deleting the data source.

For more information about how to delete a data source object from a project, see How to: Delete a Data Source in Solution Explorer (Analysis Services).