Skip to main content
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.
  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.

​
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.