Change the data source for a chart, page, or report

Creates reports that use multiple data sources.

You select a default data source when you first create a report. Every chart and control you add to the report gets its data from that data source, unless you select a different one. You can specify a data source for each chart, control, or page. You can also set a default data source for the entire report.

Change the data source for charts and controls

  1. Edit your report.
  2. Select one or more charts or controls.
  3. On the right, in the selected component's property panel, select the DATA tab.
  4. At the top of the left-hand panel, click the current data source name.
  5. Select an existing data source, or, at the bottom, click CREATE NEW DATA SOURCE.
    1. Learn more about creating a data source.
  6. If prompted, click Add to report.
Changing the data source for one component has no effect on the other components in your report.
If the new data source has a different structure (schema) from the original one, the component may display errors. You can fix those by selecting dimensions and metrics from the new data source.

Added data sources vs. Available data sources

The data source list has 2 sections: 

  • Added data sources are part of the report. If you share the report with other editors, they can use any added data sources, as long as their credentials provide access to the underlying data set.
  • Available data sources are ones you can use, but haven't yet been added to the report. 

Learn more about managing the data sources added to your reports.

Change the data source for the page or report

Setting a data source at the page or report level overrides the default data source you selected when you first created the report. New components you add use this data source instead of the default.

Set a data source for the current page

  1. Edit the report.
  2. Navigate to a specific page.
  3. Select Page > Current page settings.
  4. On the right, in Current Page Settings, select the DATA tab, then click Select Data Source.
  5. Select an existing data source or create a new one.
  6. If prompted, click Add to report.

Set a data source for the entire report

  1. Edit the report
  2. Select File > Report settings
  3. In the Report Settings panel, click Select Data Source
  4. Select an existing data source or create a new one
  5. If prompted, click Add to report.

Blend multiple data sources in a chart .

Was this helpful?
How can we improve it?