> Site index: https://usehardal.com/llms.txt
> Every content route also serves markdown at <url>.md

# How to Connect Hardal to Looker Studio

Connect Hardal analytics data to Looker Studio with the MySQL connector and build dashboards from your read-only Hardal database.

Source: https://usehardal.com/connect-hardal-to-looker-studio
Published: 2025-12-25
Updated: 2026-09-27
Author: Ecem Bircan
Category: Hardal

---

Hardal gives each signal a read-only database connection. Add that connection to Looker Studio when you need a custom dashboard, a scheduled report, or a chart that is not available in the Hardal interface.

Looker Studio connects through its built-in MySQL connector. You do not need to build an export script.

1. Log in to the [Hardal dashboard](https://app.usehardal.com/projects).
2. Select your project and signal.
3. Go to **Settings → Database**.
4. Copy the hostname, port, database name, username, and password.

Some workspace versions also show the same credentials behind the **Connect** button on a dataset.

The credentials are read-only. Treat the password as a secret even though the account cannot modify or delete data.

![Hardal database connection details](https://imge.usehardal.com/cdn/website/blog-post/hardal-to-looker-studio/rkvi29npiybvmlckzoig.png)

1. Open [Looker Studio](https://lookerstudio.google.com/).
2. Click **Create**, then choose **Data Source**.
3. Search for **MySQL** and select the Google MySQL connector.

![Add a data source in Looker Studio](https://imge.usehardal.com/cdn/website/blog-post/hardal-to-looker-studio/eio2e9plbz3x8qkxxyjs.png)

![Select the MySQL connector](https://imge.usehardal.com/cdn/website/blog-post/hardal-to-looker-studio/onu4lzhdpyszffakpnan.png)

Enter the values copied from Hardal into the matching Looker Studio fields:

| Looker Studio field | Hardal value |
|---|---|
| Hostname | Host |
| Port | Port |
| Database | Database |
| Username | Username |
| Password | Password |

Click **Authenticate**, select the table you want to report on, then click **Connect**. A Looker Studio MySQL data source connects to one table. Add another data source if a report needs a second table.

![Enter the Hardal MySQL connection details](https://imge.usehardal.com/cdn/website/blog-post/hardal-to-looker-studio/Screenshot_2025-12-17_at_12.39.03_yadfkr.png)

Looker Studio now exposes the table fields as dimensions and metrics. Check each field type before building charts, especially timestamps, numeric event values, and IDs that Looker Studio may infer as numbers.

Start with a table and a date control so you can validate the rows against Hardal. Once the totals agree, add the charts your team needs. Common examples include campaign performance by UTM source, event counts over time, conversion funnels, and product-level revenue.

If the connection fails, recheck the host and port, then confirm that your network policy allows Looker Studio to reach the database. Do not paste database credentials into a shared report description or commit them to source control.

The same database access can feed Tableau, Power BI, Hex, and other MySQL-compatible reporting tools. For the maintained setup instructions and troubleshooting steps, use the [Hardal Looker Studio documentation](https://docs.usehardal.com/user-guide/data-export/bi-connections/looker).

You can also [import Hardal first-party data to BigQuery](https://usehardal.com/import-hardal-first-party-data-to-bigquery) when you need to join it with larger warehouse datasets before visualizing it.