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:
Open Power BI Desktop
Click Get Data
Select Google Sheets
(or use “Web” connector if needed)Paste your Google Sheet URL
Select the sheet/tab with your data
Click Load
🔁 Step 3: Enable automatic refresh
After publishing your report to Power BI Service:
Go to Dataset settings
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
If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net
Haven't used this add-on yet? Try it now!
