Edit the data source connection Stay organized with collections Save and categorize content based on your preferences.

You can change a data source's connection to the underlying data. This lets you connect to different data using an existing data source.

Editing the data source connection lets you:

• Reestablish a broken connection to your data.
• Connect to a different account, Google Sheet, database table, and such.
• Edit a BigQuery custom query connection.
• Use a different connector.

Example

Suppose you have a data source based on an unfiltered Google Analytics web property and have created a Data Studio report based on that data source. Now, say you create a new filtered property in your Analytics account, and want to use that data with your existing report. To bring in the new filtered data and leave any configuration changes intact (such as calculated fields, renamed fields, or changed aggregations), you can reconnect the data source to the new property.

Who can reconnect a data source

Anyone who can edit the data source can edit its connection. For embedded data sources, this includes report editors. For reusable data sources, you must have Can Edit permission to the data source.

How to reconnect a data source

1. Edit the data source.
2. In the upper left, click EDIT CONNECTION.
3. Select the new dataset.
4. In the upper right, click RECONNECT. Data Studio shows the fields changed by this action, if any.
5. Click APPLY.

Effects of reconnecting a data source

• New fields from the dataset are added to the data source.
• Fields that have been removed from the dataset are removed from the data source.
• Fields that have been removed from thedata source are added back to thedata source.
• If there are changes to the fields or the underlying dataset, you become the new credentials owner. If the data source uses service account credentials, and you don't have permission to use that service account, you become the new credentials owner.
• Other changes you've made to the data source, such as renaming fields, changing field types or aggregations, and adding descriptions, are not affected.
• Any reports using to this data source continue to do so, however, you may need to fix any charts broken by the field changes.