The Data API allows you to extract your Operational Insight data using a token and import them into Power BI Desktop, so you can customise your data metrics.
Power BI Desktop is only available on Windows.
Step 1: Get a Token
Follow the steps below to extract your operational data.
You must be an Administrator or Safety Manager to get a token.
This token will expire after 1 month.
-
Log in to the Control Centre.
-
Go to Reports>Operational Insight.
-
Click API Setup on the top right of the screen.
-
Click Generate a new token.
-
Enter your Control Centre password.
-
Click Generate a new token.
-
Click the copy icon to the right of the token.
-
Click Download Checkit Power BI Template.
Step 2: Import Data into Power BI
Follow the steps below to import your Checkit data into Power BI Desktop.
-
Download Power BI Desktop here (if applicable).
-
Open the Checkit Power BI template from your files browser.
-
Paste the token you copied in step 7 above into the authKey field
-
Enter the number of weeks you want to load data on in the lastXWeeks field.
-
Click Load.