Data Studio on BigQuery
  • 27 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

Data Studio on BigQuery

  • Dark
    Light
  • PDF

Panoply on BigQuery

To connect Google Data Studio to your Panoply data warehouse built on BigQuery:

  1. In Panoply, click on BI Connection in the top menu to view your connection details.

    bi-connection-details-data-studio-1.png
  2. Sign In to your Data Studio account using these credentials. 

    data-studio-2.png
  3. Once in Data Studio, click on Create > Data Source to add a new Data Source.

    data-studio-3.png
  4. On the next screen, under Google Connectors, select BigQuery.

data-studio-4.png

  1. Click on Authorize to connect.

data-studio-5-1.png

  1. You will be re-directed to the Sign in with Google page. Select the Google account to continue.

data-studio-6.png

  1. You have successfully added Google BigQuery as your Data Source in Google Data Studio.
  2. Next, click on MY PROJECTS.
    1. Select Project > Dataset > Table, then click Connect.

data-studio-7-1.png

  1. The Project name can be located under the BI Connection tab on your Panoply account.
  2. To connect with all Panoply’s native Data sources, please select “panoply” under Dataset.
  3. Click Connect.
  4. Your Data source will be re-named with your table name. Click on Create Report to get started.

data-studio-8-1.png

  1. You have successfully connected Data Studio to your BigQuery data warehouse.

Was this article helpful?