When you create a new report in Looker 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 Looker Studio:In this article:
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 Looker Studio partners via the Community Connectors developer program.
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 Looker 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 Looker Studio, and you can update the snapshot whenever you want.
File upload data sources let you import CSV data into Looker 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 uses the credentials of the data source owner to authorize access to the data set. This option lets you share reports that use this data source without requiring report viewers to have their own access to the underlying data set.
Before sharing a report or data source that uses Owner's credentials, be sure you trust the person or persons with whom you share them.
- Viewer's credentials requires anyone attempting to view the data provided by this data source to have their own access to the data set.
- Service account credentials uses a special type of Google account that is intended to represent a non-human user that can authenticate and be authorized to access your data.
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.
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. When you share or copy the report, any embedded data sources are shared or copied as well.
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.
- Edit your report.
- In the menus, select Resource 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.