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

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