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.
- Edit your report.
- In the menus, select Resource > Manage added data sources.
- Locate the data source in the list, then to the right, click Duplicate.
- In the data source configuration page, select the data set for the new data source, then click RECONNECT.
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.
- Sign in to Looker Studio.
- At the top of the page, click Data Sources.
- Browse, or use the search box in the upper right, to locate the data source you wish to edit.
- Click that data source.
- In the upper right, click Make a copy .
- In the confirmation dialog, click COPY DATA SOURCE.
- 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:
- Edit the data source.
- In the upper right, click Share.
- Select the Manage access tab.
- Turn on the Disable options to download, print, and copy for commenters and viewers option.
- 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.