Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

Copy a data source

Create different versions of your data sources.

Copying a data source lets you create variations of your reports. For example, you can copy a template 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 while you experiment.

In this article:

Duplicate a data source from within a report

Report editors can copy any embedded data sources in the report. Report editors can also copy reusable data sources if they have edit access to that data source.

  1. Edit your report.
  2. In the menus, select Resource > Manage added data sources.
  3. Locate the data source in the list, then to the right, click Copy icon. Duplicate.
  4. In the data source configuration page, select the data set for the new data source, then click RECONNECT.
If you copy a reusable data source from the Manage added data sources page, the new data source is embedded in the report.

Copy a data source from the home page

You can make a copy of a reusable data source from the home page. You must be the owner of or have edit access to the data source to do this.

  1. Sign in to Looker 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 Make a copy Copy icon..
  6. In the confirmation dialog, click COPY DATA SOURCE.
  7. In the data source configuration page, select the data set for the new data source, then click RECONNECT.

Field changes

If the new data set you select for the copy has different fields from the original, you'll see those changed fields listed. You can edit the data source configuration by clicking GO TO FIELDS.

Learn more about refreshing data source fields.

Update data credentials

If the data credentials used by the original data source are owned by another person, you can use your own credentials for the new data source by clicking UPDATE CREDENTIALS.

Learn more about data credentials.

How copying a data source works

When copying a data source, Looker 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.

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. Select the Manage access tab.
  4. Turn on 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?
Search
Clear search
Close search
Google apps
Main menu
14497341190086857263
true
Search Help Center
true
true
true
true
true
102097
false
false