Edit a data source

Modify and configure an existing data source.

You can edit data source in the following ways:

Edit a data source from the home page

  1. Sign in to Data Studio.
  2. At the top of the Data Studio home page, click Data Sources.
  3. Browse or search for the data source you wish to edit.
  4. Click that data source in the list.
Only reusable data sources appear in this list. To edit an embedded data source, follow the steps below.

Edit a data sources from within a report

  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 Edit Edit.

You can also edit the data source for a specific component:

  1. Edit your report.
  2. Select a component.

On the right, in the DATA tab, edit the data source by clicking Edit.

The data source editor interface

Data source editor interface map.

Data source editor legend

  1. Data source name. Click to change the name.
  2. Version history. View and restore previous versions of the data source Restore.
    1. Next to version history is Share this data source with other people Share icon .
  3. Data source options:
    1. Data  credentials. Determines how data from this data source can be viewed by others.
    2. Data freshness. Balance data updates with report performance.
    3. Community visualizations access. Allow this data source to provide data to community visualizations.
    4. Field editing in reports. Allows report editors to change field names and aggregations, apply analytical functions, and set field display options without needing to edit the data source.
  4. Make a copy of this data source.
  5. Create report. Create a new report from this data source.
  6. Explore. Create a new exploration from this data source.
  7. Add a field. Create a calculated field.
  8. Edit connection. The data source owner can reconnect the data source.

    (Not shown: Filter by email address. Add row level security to your data.
  9. Fields. Dimensions appear in green chips, metrics in blue chips, parameters in purple chips. Click a field to give it a new name. To perform other field actions, click More More menu.
  10. Field type. Determines the kind of data contained in the field. Click the drop-down menu to change the type. Use caution: changing field types can have a big impact on your reports.
  11. Aggregation. Determines how the field is summarized. Click the drop-down menu to change the aggregation. Fields with AUTO aggregation can't be changed.
  12. Calculated fields. Click fx to edit the field formula.
  13. Refresh fields. Click to update the data source with any structural changes made to the underlying data set.
  14. Field count. Displays the number of fields in the data source.
You must have edit access to the data source to perform any of the actions listed above.
Edit access to a data source does NOT grant you access to the underlying data set.

Who can edit a data source

To modify a data source, you must have at least edit access to the data source (for reusable data sources), or edit access to the report (for embedded data sources). Report viewers (users who only have Can View access to the report) can only see the data as provided by the visualizations and charts on the report.

If you have Can Edit access to a data source, you can:

If you are the owner of the data source, or the owner of the data credentials used by the data source, you can also:

If you are the owner of the data source, you can also:

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue