Time in Status Data Export Through API - Power BI

Overview

You can connect Time in Status data to Power BI using Google Sheets as an intermediate layer.

This approach is recommended because:

• It avoids direct API configuration in Power BI

• Data sync and token handling are already managed in Google Sheets

• Setup is simpler and more stable

🔗 Step 1: Set up Google Sheets integration

Before connecting Power BI, you need to configure data export to Google Sheets.

👉 Follow the full guide here:
[Time in Status → Google Sheets Integration Guide]

This setup will:

• Connect your Time in Status report via API

• Automatically sync data into a Google Sheet

• Handle token refresh and scheduling

📈 Step 2: Connect Power BI to Google Sheets

Once your data is available in Google Sheets:

1. Open Power BI Desktop

2. Click Get Data

3. Select Google Sheets
   (or use “Web” connector if needed)

4. Paste your Google Sheet URL

5. Select the sheet/tab with your data

6. Click Load

🔁 Step 3: Enable automatic refresh

After publishing your report to Power BI Service:

1. Go to Dataset settings

2. Configure Scheduled refresh

🔄 How updates work

After setup:

• Google Sheets automatically syncs data from Time in Status

• Power BI reads updated data from the sheet

• Your dashboards stay up to date without manual work

🔐 Maintenance

The only required maintenance:

• Refresh token expires approximately every 90 days

• When it expires:

  • Update tokens in Google Sheets (via the script menu)

  • No changes needed in Power BI

✅ Result

✔ Fully automated data pipeline
✔ No manual exports
✔ No API setup inside Power BI
✔ Minimal ongoing maintenance