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

# Power BI

> How to connect Power BI to Pike with the Pike connector, load project, time, finance, and capacity tables, and schedule refresh.

The Pike connector for Power BI loads Pike data into Power BI Desktop and the Power BI service: projects, phases, tasks, time entries, members, teams, customers, deals, invoices, expenses, allocations, and time off. A starter report includes utilization, project margin, and unbilled time pages.

## Connect Power BI

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 Power BI Desktop, choose **Get data** and select the **Pike** connector.
3. Paste the API secret when prompted and choose the tables to load.
4. Publish to the Power BI service and set up scheduled refresh there.

## 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 includes utilization, project margin, and unbilled time pages.

### Refresh

Scheduled refresh in Power BI works through the Power BI service.

## Disconnect

Revoke the API secret in Pike to stop the connector. Reports keep the data from their last refresh.

## 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.
* Refresh runs on the schedule you set in the Power BI service.

## Related

* [Power BI integration overview](https://usepike.com/integrations/power-bi): Tables, the starter report, and FAQs.
* [Looker Studio](https://usepike.com/docs/integrations/looker-studio.md): The same tables in Looker Studio.
* [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.