You can replace the data source for selected charts and controls, the current page, or the entire report. Reasons you might want to do this include:
- Copying a report and replacing your data source with a client's data source.
- See also: Add a data control to a report.
- Testing a report with no email filters applied, then switching to a data source with email filtering.
- Switching the data source for a selected component from one account, sheet, or database table to another.
- Overriding the default page or report-level data source.
What happens when you replace a data source
When you replace a data source in your report, Looker Studio tries to map the fields in the old data source to the fields in the new data source based on a number of matching criteria, including field ID, field name, and other configuration information from the report itself. Looker Studio won't try to map your old fields in calculated fields and filters.
If no suitable match is found, your report may display components with the message:
Invalid/Missing dimensions, metrics, filters.
To fix this, edit the incomplete components and select new dimension, metric, sorting, and/or date range fields.
Replace a component data source
- Edit your report.
- Select one or more charts or controls.
- On the right, in the selected component's property panel, select the Setup tab.
- Click the current data source name.
- Select an existing data source, or, at the bottom, click NEW DATA SOURCE.
- Learn more about creating a data source.
- If prompted, click Add to report.
Replace a page or report-level data source
Most reports won't have page or report-level data sources unless you've explicitly set them. Setting a data source at the page or report level has no effect on existing components in your report. Instead, new components you add use the page or report-level data source by default.
Replacing a page or report-level data source follows the same process as outlined above.
Replace the data source for the current page
- Edit your report.
- Navigate to a specific page.
- Select Page > Current page settings.
- On the right, in Current Page Settings, select the Setup tab, then click the current data source (or Select Data Source, if no data source has been added).
- Select an existing data source or create a new one.
- If prompted, click Add to report.
Replace the data source for the entire report
- Edit your report.
- Select File > Report settings.
- On the right, in Report Settings, click the current data source (or Select Data Source, if no data source has been added).
- Select an existing data source or create a new one.
- If prompted, click Add to report.