Copy a data source

Save time and preserve your work.

You can duplicate any data source to which you have access. This makes it easy to create customized variations of your reports. For example, you can create multiple copies of a report, then attach different versions of the data source, with modified dimensions, metrics, or calculated fields, to support different sets of users. You can also make backup copies of a data source for safe keeping.

In this article:

Copy a data source

Data sources can only be copied when edited via the DATA SOURCES Home page.

  1. Sign in to Data Studio.
  2. At the top of the page, click Data Sources.
  3. Browse, or use the search box in the upper right, to locate the data source you wish to edit.
  4. Click that data source.
  5. In the upper right, click Copy icon..
  6. In the confirmation dialog, click COPY DATA SOURCE.
  7. If the Connectors panel appears, select the data set for the new data source, then click RECONNECT.

The Fields panel for the new data source appears, with the name "Copy of [original data source name]." Click the name to change it.

How copying a data source works

When copying a data source, Data Studio tries to make sure you have access to the data by reconnecting to the underlying data set. If access can't be confirmed, you'll see the connectors panel, where you can select the data set to use. Google Analytics, Google Ads, and file import data sources always require you to explicitly reconnect to the data set. If the fields in the new data set don't match the schema of the copied data source, you'll see a message detailing the new fields being added and/or missing fields being removed.

Whenever possible, the copied data source inherits the following from the original:

  • Dimensions
  • Metrics
  • Calculated fields
  • Field types
  • Aggregations
  • Data source credentials

Things that might prevent the data source from being duplicated exactly include:

  • Selecting a new data set that doesn't exactly match the original
  • Selecting a new data set to which you don't have the same access as the original
  • Changes made to the original data set while the copy is in progress

Copying a data source never grants direct access to the data set.

Copying a data source does not copy any reports that use the data source. Reports and data sources must be copied separately.

Disable option to copy a data source

You can prevent other people from copying your data source using the Advanced > Owner settings of the sharing dialog. You must be the owner of the data source to see these settings.

To prevent a data source from being copied:

  1. Edit the data source.
  2. In the upper right, click Share icon Share.
  3. In the bottom right of the Share with others dialog, click Advanced.
  4. In the bottom right of the Sharing settings dialog, enable the Disable options to download, print, and copy for commenters and viewers option.
  5. Click Done.

Limits of copying a data source

Copying a data source doesn't copy or validate the actual data. It only duplicates the data source schema. If you connect the data source to a different data set from the original, it's possible that calculated fields may not return the same results as the original data source. For example, a REGEX_MATCH function that works in the original data source might look for data that doesn't exist in the new data set.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue