Connect a Time in Status report to Power BI without configuring the API directly — Google Sheets handles the connection for you.
There are two ways to connect a Time in Status report to Power BI: through Google Sheets, or with a custom script that connects Power BI directly to the API. This page documents the Google Sheets path — it's the maintained, supported route. If you'd rather build a direct connection yourself, see the Limitations section below before you start.
The Google Sheets integration handles the API connection, authorization, and token refresh; Power BI only needs to read the resulting sheet and refresh on a schedule.
Before you begin
-
Set up the Time in Status → Google Sheets Integration Guide first. This page assumes that sync is already running and producing data in a sheet.
-
You need Power BI Desktop installed to build the report.
Connect Power BI to your data
-
Open Power BI Desktop.
-
Select Get Data.
-
Select Google Sheets (or the Web connector if needed).
-
Paste your Google Sheet URL.
-
Select the sheet/tab with your data.
-
Select Load.
-
Publish the report to Power BI Service.
-
Go to Dataset settings and configure Scheduled refresh.
Behavioral details
-
Google Sheets syncs data from Time in Status on its own schedule; Power BI simply reads whatever is currently in the sheet on each scheduled refresh.
-
No manual exports and no API configuration inside Power BI are required — both are handled by the Google Sheets layer.
Limitations
-
You can connect Power BI directly with a custom script, but be aware of this limitation: Atlassian uses rotating refresh tokens. Every time you use a refresh token, Atlassian invalidates it and issues a brand new one. Power Query cannot save that new refresh token back anywhere — it just discards it.
-
The Google Sheets script's refresh token expires roughly every 90 days. When it expires, sync stops until the token is updated in Google Sheets (via the script menu) — no action is needed in Power BI itself.
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!