Looker is an enterprise platform for business intelligence, data applications, and embedded analytics that helps you explore and share insights in real time. The Looker Studio Looker connector allows you to access data from your Looker Explores within Looker Studio by adding an Explore as a data source in a Looker Studio report.
Before users can view Looker data in a Looker Studio report, a Looker user with the appropriate permissions must perform these tasks to connect Looker to Looker Studio:
- A Looker user with an admin role — also called a Looker admin — must request access. To request access, complete the following steps:
- Fill out the form, which is accessed through the Enroll now button shown later on this page.
- Receive enrollment confirmation.
- Enable the integration in the Looker instance using the Labs toggle labeled Data Studio.
- A Looker user with at least
explorepermissions must connect the Looker instance as a data source in a Looker Studio report using the Looker connector.
- Connect Looker to Looker Studio
- Use the Studio Looker connector
- View and edit the data source configuration
- Add more Looker Explores
- Add fields to the report chart
- Control access to Looker data in Looker Studio
- View Looker data on a report
- Limits of the Looker Studio Looker connector
- Related resources
Connect Looker to Looker Studio
To enable the connection between Looker and Looker Studio, a Looker admin must enable the Data Studio Labs feature on the Labs page in the Admin section of their Looker instance.
The Data Studio Labs feature is hidden by default. For the Labs feature to become visible, you must enroll in the Looker Studio/Looker Integration Public Preview. Once your enrollment is complete, the Data Studio Labs feature will be visible on the Looker instance Labs page. This is not the same as the Link to Data Studio from Explore Labs feature, which adds a menu option when you're viewing an Explore in Looker.
Enable or disable the Labs feature
After you've enrolled in the Labs feature and received confirmation of your enrollment, you can enable the Labs feature by completing these steps:
1. Navigate to the Labs page in the Admin section of your Looker instance.
2. Enable the toggle next to the Data Studio Labs listing.
When the Data Studio Labs feature is enabled, users can link their Google account with their Looker account to access a specified Looker instance through Looker Studio. Account linking requires user authentication and enables Google to see, edit, refresh, sync, and move data using the Looker API on behalf of the user.
To disable the ability to add a Looker Explore as a data source in Looker Studio, a Looker admin must disable the Data Studio Labs feature on the Labs page in the Admin section of their Looker instance.
To disable the Labs feature:
1. Navigate to the Labs page in the Admin section of your Looker instance.
2. Disable the toggle next to the Data Studio Labs listing.
Additionally, Looker admins can enable or disable the Link to Data Studio from Explore Labs feature, which exposes a menu option in a Looker Explore that links directly to a Looker Studio report. The Data Studio Labs feature must also be enabled for the Link to Data Studio from Explore Labs feature to operate.
Use the Looker connector
You can connect a Looker Explore to a new embedded data source in a report or to an existing (reusable) data source. To use the Looker Studio Looker connector to create a data source that connects to an Explore in a Looker instance, you must perform the following steps:
- Connect to a Looker instance and link your Looker and Google accounts.
- Select a model and an Explore.
Connect to a Looker instance
- In a report, click Add data in the report toolbar.
- In the Add data to report page, click the Connect to data tab.
- Under Google Connectors, click the Looker connector.
- Enter the URL for the Looker instance from which you would like to source your data. This is the URL that you use to access Looker on your browser.
- If the instance URL is invalid, Looker Studio displays the message "Invalid Looker URL or the Looker URL does not support account linking. Please use different Looker URL."
- If you have previously connected a Looker instance as a data source, that Looker instance name appears under Saved Looker Instances. You can click the name of a Looker instance and proceed to the step of selecting a model.
- Click Connect Looker Account.
- In the authorization pop-up, click Agree and continue to link your Google account credentials to your Looker account credentials. You can link one Google account to one Looker account for each Looker instance that you connect to Looker Studio.
- Click AUTHENTICATE in the Looker instance pop-up.
Note that in linking your accounts, the instance URL is stored by Google and this is outside of the Looker environment. You can unlink your Google and Looker accounts from the Account Linking page in your Google Account profile. Unlinking your accounts will prevent the data source from connecting to Looker data.
Now you are ready to select a model–Explore pair to connect to as a data source.
Select a model and an Explore
Once you have connected to a Looker instance, the list of models that are associated with that instance automatically populates a new panel called Models. You can now select a model–Explore pair to connect to as a data source.
To select a model:
- Scroll the list or click the magnifying glass icon to open a search field where you can enter the name of a specific model.
- Hover over a model name to see the model filename as it appears in the Looker project.
- Click on the model name to select the model. A new panel will populate with the list of Explores that are associated with that model.
- To select an Explore, scroll the list or click the magnifying glass icon to open a search field where you can enter the name of a specific Explore.
- Click on the Explore name to select the Explore.
- Click Add. A pop-up appears with information about the data source's selected Explore and model.
- To confirm your model and Explore selection for this data source, click ADD TO REPORT. To return to the Add data to report panel, click CANCEL. Optionally, check the Don't show me this again box to prevent seeing this pop-up when you edit this data source.
It may take a few minutes to add the new data source to your report. Looker data sources have the format Looker Explore name - Looker model name.
View and edit the data source configuration
The data source configuration contains information about who can view or edit the data source, how often the data refreshes, whether community visualizations can be accessed, and whether fields can be edited for this data source. You can also view and edit the fields that appear in the Data panel.
To access the data source configuration window:
1. Edit your report.
2. Open the list of data sources from either the Resource menu or the Data panel:
- From the Resource menu, select Manage added data sources. Click on the open icon next to the data source name to open a new window that displays the Looker data source configuration.
- From the Data panel, hover over the Looker logo for the desired Looker data source. Click the edit icon to open an adjustable overlay that displays the Looker data source configuration. To expand this to a full-size window, click the leftward-facing arrow next to the name of the data source at the top of the overlay.
3. Select Close in the upper right of the window to return to your report.
Learn more about editing a data source.
Add more Looker Explores
Once your report's data source is connected to Looker, you can add more Looker Explores — even those not belonging to the same Looker model as other data sources in the report — to your report as additional data sources.
To add a new Looker Explore to your report, follow the instructions for adding a Looker Explore in the Use the Looker Studio Looker connector section of this page.
- To connect to a different Looker instance, enter a different Looker instance URL in the Connect to a Looker Instance panel of the Connect to data tab of the Add data to report page. If this instance is associated with a different Looker account, you will need to authorize the linking between your Looker and Google accounts.
- To connect to a new model–Explore pair from a Looker instance that you have already used to connect as a data source, first select the instance name under Saved Instances, and then select a new model and Explore.
- To connect to an existing model–Explore data source, navigate to the My data sources tab of the Add data to report page. Looker data sources have the format Looker Explore name - Looker model name. Select a new data source and click Add.
After you have added your data source, refresh your report. Your new data source appears in the Data panel. Click on the data source name to expand it, and drag fields into your report as needed.
Add fields to the report chart
When you refresh your data in Looker Studio, data is also refreshed in Looker as if you had clicked Clear Cache and Refresh from the Looker Explore.
The fields from your Looker data source are displayed in a different format from how they appear in Looker. The Explore field picker defaults to a more user-friendly format of the Explore and its views, dimensions, dimension groups, measures (known as metrics in Looker Studio), and joins. In Looker Studio, the fields appear in your report in the format Looker-view-name field-name, with all the Explore's dimensions listed followed by all the Explore's metrics.
For example, in Looker, an Explore called Flights has the views Carriers, Destination, Flights, and Origin. The Carriers view has the dimensions Carrier Name, Code, and Name, and no view labels have been specified:
In the corresponding Looker Studio Looker data source called Flights - FAA, these dimensions appear as Carriers Carrier Name, Carriers Code, and Carriers Name:
Learn more about how to edit fields in your reports.
Control access to Looker data in Looker Studio
The default data credentials for Looker data sources are Viewer's credentials.
Viewers of data from Looker data sources must provide their own credentials to access the Looker dataset. Providing these credentials links their Google account with the Looker account that is associated with the connected Looker instance. In addition, their Looker user account must have at least
clear_cache_refresh permissions for the models on which the connected Looker Explore is based. Looker admins manage user permissions.
Revoking your credentials will prevent the data source from connecting to Looker data until the credentials are updated.
Learn more about how to set and revoke your data credentials.
View Looker data on a report
clear_cache_refreshpermissions for the model on which the Explore is based to view data from Looker data sources.
Before you can view data from a Looker data source that was created by another user, you must link your Google account to your account for the Looker instance to which the report is connected.
An Authorization Required message on charts indicates when you must authorize the Looker connector. To authorize the connector:
- Click the Authorize now link in the desired chart.
- In the Looker Studio authorization request pop-up, click AUTHORIZE.
- In the Google authorization pop-up, click Allow and continue to link your Google account credentials to the Looker credentials for the Looker instance that is displayed in the authorization pop-up.
You can unlink your Google and Looker accounts from the Account Linking page in your Google Account profile.
Limits of the Looker Studio Looker connector
Scheduling email deliveries and downloading reports are disabled for reports with a Looker data source connection. Although the option to perform each action is available, the delivered and downloaded reports will not contain data.
Calculated fields are disabled for Looker data sources.
Exceptionally large models (generally >100 Explores) may cause long delays or timeouts during the data source creation process.
|The Data Studio Labs feature is still not visible on the Looker instance's Labs page after you received the confirmation email from the Preview team||Click Update next to the License Key field on the Settings page in the Admin section of the Looker instance.|
|Cannot connect a Looker instance||
|No Explores found||Select a different Looker model.|
If you encounter issues while using the Looker connector, please report them by using this bug report form. Users may also review and add to previously reported issues on the bug tracker. The Preview team will review all submissions.