Create a data source
Creating a data source of any type consists of essentially the same steps:
- Sign in to Data Studio. After signing in, you'll see the Home page, with the REPORTS tool selected.
- On the left, click the DATA SOURCES tab.
- Click .
- Select the type of connector you want from the list.
The connectors page lists both first-party Google connectors, and third-party connectors built by the Data Studio community. Community connectors may cost money to use. If you have issues using a community connector, please contact that connector's developer directly.
- Select the data set. Depending on the type of data you're connecting to, this will involve specifying the exact accounts or files you want to use. See related resources for more information on the different connector types.
- Click CONNECT. The data source Fields tab will open.
- Use the Fields tab to add metrics, change the field types, change the aggregation type , and rename any fields, as needed.
- (Optional) Change the data source credentials. This controls who can see the data provided from this data source
- (Optional) Click the default data source name to rename it.
- Click Create Report.
Data source schema
A Data Studio data source has a specific structure and configuration, known as a schema. The data source schema determines the following:
- What fields are available to use in your reports
- What type of data those fields contain (semantic type)
- How numeric fields are summarized (aggregation)
The data source configuration also controls how it accesses the underlying data, (via credentials), who has access to view or edit the data source (via sharing), and other options.
What fields are available for reporting?
The specific fields available in a data source depends on the data source type and the underlying data set. Some types of data sources include all the fields from the data set (for example, Google Sheets, BigQuery). Other types of data sources provide a subset of all the fields in the original data set (for example, Google Analytics). Refer to the individual connector articles for more information.
You can also create new dimensions and metrics in the data source using calculated fields.
Create a data source for a different Google account
Access to Google data is based on the account with which you sign into Data Studio. This means that a data source can only directly connect to a single Google account. To connect Data Studio to different accounts, you have the following options:
Share the data with yourself
Suppose you want to create a report with data from Google Sheets belonging to 2 different Google accounts? One solution is to share the Sheet with each account. Then either account can create data sources using those Sheets.
Another solution is to create data sources in one account, then share those data sources with the other account. For example, suppose you have data in accounts A and B, and you want to create Data Studio reports using account A. To include data from account B, you could do the following:
- Sign into Data Studio using the account B.
- Create the data source.
- Make sure the data source uses Owner's Credentials.
- Share the data source with account A, with edit permission.
You can then return to account A and use the shared data source in your reports.
Note that only the data source owner can refresh or reconnect a data source, so you'll need to make any schema changes to the shared data source as account B.
Use the data control
The data control allows a report viewer to switch the report to any account to which they have access. The data control is available for a subset of the available connectors.