> ## Documentation Index
> Fetch the complete documentation index at: https://usepike.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Looker Studio

> How to connect Looker Studio to Pike with the Pike partner connector and build reports on project, time, finance, and capacity data.

The Pike partner connector for Looker Studio loads the same tables as the Power BI connector: projects, phases, tasks, time entries, members, teams, customers, deals, invoices, expenses, allocations, and time off. It authenticates with a Pike API secret and includes a starter report template.

## Connect Looker Studio

The connector authenticates with a Pike API secret.

1. Create a Pike API secret. A workspace admin creates secrets, as described in the [Open API docs](https://usepike.com/docs/integrations/open-api.md).
2. In Looker Studio, add a data source and choose the **Pike** partner connector.
3. Paste the API secret when prompted and choose a table.
4. Start from the starter report template, or build your own report.

## What syncs

The connector exposes these tables.

| Pike table |
| - |
| Projects |
| Phases |
| Tasks |
| Time entries |
| Members |
| Teams |
| Customers |
| Deals |
| Invoices |
| Expenses |
| Allocations |
| Time off |

### Starter report

A starter report template is included.

## Disconnect

Revoke the API secret in Pike to stop the connector.

## Permissions

The connector reads with the API secret, which is scoped to one workspace. Only admins can manage API secrets.

## Limits

* The connector reads from Pike. It does not write.

## Related

* [Looker Studio integration overview](https://usepike.com/integrations/looker-studio): Tables, the starter report, and FAQs.
* [Power BI](https://usepike.com/docs/integrations/power-bi.md): The Pike connector with scheduled refresh.
* [Data warehouse sync](https://usepike.com/docs/integrations/data-warehouse.md): Hourly sync to BigQuery or Snowflake.
* [Metric catalogue](https://usepike.com/docs/dashboards/metric-catalogue.md): How Pike defines each metric.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.