About data sources

When you create a new report in Data Studio, you either add an existing data source, or create and add a new one. You can add more data to the report at any time.

Here's how data sources fit into the big picture of Data Studio:

In this article:

Data model

Having a consistent definition for the metrics and dimensions that are shared across your business provides a common platform for data analysis.

Data sources provide the structure (schema) of the fields you or other report editors can use to create your reports. The data source is where you model your data: for example, by creating calculated fields, adding parameters, and adjusting data types.

Data sources and connectors

Data sources use connectors to fetch your data from a specific platform, system, or product. You can use free connectors built by Google to access data such as Google Sheets, Google Ads, Google Analytics, and other Google Marketing Platform products, and more. You can also use connectors built by Data Studio partners via the Community Connectors developer program.

Community connectors may cost money to use. If you have issues using a community connector, please contact that connector's developer directly.

Visit the Connector Gallery.

How (and when) data sources fetch your data

Most data sources maintain a live connection to your data. Your data remains in the underlying data set and is not imported into Data Studio. However, for better performance, your data may be stored temporarily in an in-memory cache. Some data source connections let you adjust how often the cache is refreshed.

For even faster performance, you can use an extracted data source. The Extract data connector creates a static snapshot of your data. The extracted data is stored securely in Data Studio, and you can update the snapshot whenever you want.

File upload data sources let you import CSV data into Data Studio. Using a file upload data source, you can visualize information not otherwise supported by the other connectors. File upload data sources behave in many ways like extracted data sources, except you can't update them automatically. You must import new data manually.

Control access to the data

Access to the data provided by a data source is handled by data credentials:

Owner's credentials lets other people view or create reports that use this data without requiring them to have their own access to the data set.

Viewers credentials requires each user of the data source (or reports built using the data source) to provide their own credentials to access the data set. If they do not have access to the data set, they won't be able view the data in reports, or edit the data source fields.

Learn more about data credentials.

Filter data by email address of the viewer

Filtering a data source by viewer email address lets you provide "row-level" security over the data. Only the records in your data containing the signed-in viewer's email appear in the report.

Learn more.

Embedded vs. reusable data sources

Data sources can be either embedded or reusable. Reports can include both embedded and reusable data sources.

Data sources you create while editing a report are embedded in the report. To edit an embedded data source, you do so within that report. Embedded data sources make collaborating on reports and data sources easier. Anyone who can edit the report can also edit the data source, as well as modify its connection.

Data sources that you create from the home page are reusable. You can reuse these data sources in different reports. Reusable data sources let you create and share a consistent data model across your organization. Only people you share it with can edit a reusable data source. Only the owner of the data source's credentials can modify the connection.

To see whether the data sources in a report are embedded or reusable:
 
  1. Edit the report.
  2. In the menus, select Resource and then Manage added data sources.

Share and copy data sources

When you share or copy a report, all of its embedded data sources are shared or copied along with it. You don't need to share embedded data sources separately from the report. This means that other report editors can modify the data source.

Reusable data sources aren't copied or shared when you copy or share a report. If you want someone else to be able to modify a reusable data source, then you must share it with them explicitly.

Note that you don't need to share a reusable data source in order for viewers of the report to see the data, or for editors to use the fields provided by the data source to create charts and controls in the report.

Learn more about sharing reports and data sources.

Was this helpful?
How can we improve it?
true
What's new in Data Studio

Learn about new features and recent changes.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
102097
false