Delete a data source

In Data Studio, you can remove, delete, and restore data sources to manage your reports and maintain data integrity. Removing a data source disconnects it from your reports, while deleting a reusable data source permanently removes it from Data Studio.

Remove a data source from a report

If embedded and reusable data sources are no longer needed, you can remove them from your reports by following these steps:

1. Edit your report.
2. Select Resource Manage added data sources.
3. Locate the data source in the list.
4. To the right, click REMOVE .

Effects of removing a data source

When you remove a data source from a report, note the following effects:

• Any report components that use the data source display a "Configuration incomplete" error. To fix this error, add a new data source to the component.
• Removing a reusable data source from a report doesn't affect other reports that use that data source and doesn't move the data source to the Trash.
• Removing an embedded data source disconnects it from the report but doesn't permanently delete the data source. Data Studio permanently deletes embedded data sources only when you permanently delete the parent report. To permanently delete an embedded data source without deleting the report, you can convert the embedded data source to a reusable data source and then delete it.

Move reusable data sources to the Trash

You can remove one data source or multiple data sources at once.

Moving a data source to the Trash also removes the data source from any reports that use it.

Move a single reusable data source to the Trash

Caution: If you move a data source to the trash and that data source is connected to one or more reports, Data Studio won't display a warning. Data Studio will label the data source as (Unknown) in these reports. Use the Manage Added Reports option to see the reports that use a given data source before you remove that data source.

To remove a reusable data source from the home page list, follow these steps to move it to the Trash:

1. Sign in to Data Studio.
2. Navigate to the DATA SOURCES tab.
3. Locate the data source that you want to remove.
4. Hover over the data source name. Then, on the right, click More options .
5. Click Remove .

Move multiple reusable data sources to the Trash

To remove multiple reusable data sources from the home page list at once, follow these steps:

1. Sign in to Data Studio.
2. Locate the data sources that you want to remove.
3. To select multiple adjacent data sources, hold down the Shift key and click the data sources. To select multiple non-adjacent data sources, hold down the Ctrl key (PC) or the command key (Mac) and click the data sources.
4. Click Trash selected items .
5. In the Move items to the trash? dialog, click Confirm to move the data sources to the Trash.

Permanently delete a reusable data source

Data sources in the Trash remain undeleted unless you permanently delete them. You need to own the data source to delete it.

1. Sign in to Data Studio.
2. Navigate to the DATA SOURCES tab.
3. On the left, select TRASH.
4. Locate the data source that you want to delete, and then click Options .
5. Click Delete forever .

Warning: You can't undo this action.

Restore a reusable data source

You can restore items that are in the Trash. Restoring a reusable data source adds it back to any reports to which it had been previously added. To restore a reusable data source, follow these steps:

1. Sign in to Data Studio.
2. Navigate to the DATA SOURCES tab.
3. On the left, select TRASH.
4. Locate the data source that you want to restore, and then click the options menu .
5. Click Restore .

Version history and deleted data sources

You can't use version history to restore any data sources that have been permanently deleted.

Related resources

• Delete a report
• Manage added reports and data sources
• Version history
• Embedded data sources