Power BI

This method connects Power BI Desktop directly to the TimeCamp REST API. It's free and easy to set up.

Step 1: Download the example report

Download our pre-configured Power BI report template:

Download TimeCamp Power BI Report

Step 2: Open the report in Power BI Desktop

1. Open Power BI Desktop (free download from Microsoft)
2. Open the downloaded .pbix file

Step 3: Replace the API token with your own

1. In Power BI Desktop, go to Home → Transform data → Edit parameters
2. Paste your TimeCamp API token into the "ApiToken" parameter
3. Click OK, then Apply changes

Where to find your TimeCamp API token:

• Log in to TimeCamp
• Go to Settings → Your Profile
• Copy your API token from the profile page

Instruction

Step 4: Refresh the data

Click Refresh to load your TimeCamp data into the report.

Export data to a database, then connect Power BI

This method gives you the most flexibility and works with both Power BI Desktop and Power BI Online. We recommend using Google BigQuery as your data warehouse.

Step 1: Export TimeCamp data to a database

Use our open-source data pipeline to export your TimeCamp data:

1. Visit the TimeCamp Data Pipeline repository on GitHub
2. Follow the setup instructions in the README
3. Run the pipeline to export your data to your preferred destination:
   • Google BigQuery (recommended)
   • PostgreSQL
   • MySQL
   • DuckDB
   • CSV/Parquet files

Available datasets you can export:

• Time entries with project/task details
• Projects & tasks hierarchy
• Computer activities (desktop app tracking)
• Users with group information
• Application names and categories

Step 2: Connect Power BI to your database

Once your data is in the database, connect Power BI to it:

For Google BigQuery:

1. Open Power BI Desktop or go to Power BI Online
2. Click Get Data → Database → Google BigQuery
3. Sign in with your Google account that has access to BigQuery
4. Select your BigQuery project and dataset
5. Choose the tables you want to import (entries, tasks, users, etc.)
6. Click Load to import the data

For other databases:

Use the appropriate connector in Power BI (PostgreSQL, MySQL, etc.) and enter your database credentials.

Benefits of this approach

• Works with Power BI Online (cloud) and Desktop
• Automatic data refresh scheduling
• Better performance for large datasets
• Full control over your data

Please contact us at sales@timecamp.com if you are interested in self-hosted version of TimeCamp.