Clockify - Power BI Integration
For inquiries please open an issue:
https://github.com/OscarValerock/Clockify-PowerBI/issues
Blog Post
If you want to know more about the connector, what you can learn from it, and its development story, I invite you to read my blog post: https://www.bibb.pro/post/clockify-power-bi-template
Searching for a developed Clockify report and model?
Clockify - Power BI Template - Lifetime updates
https://store.bibb.pro/l/clockify
Clockify Power BI
This repository contains two ways to getting data from Clockify into Power BI:
(1) Custom connector (2) Power BI template.
For any of the methods you will need the following
A clockify account: https://clockify.me/signup
Once you have the account, you will need the API Key.
An API Key https://clockify.me/user/settings
If you need more info from the API, here is the link to the documentation. https://clockify.me/developers-api
0. Wallkthrough video.
1. Clockify Custom Connector
For more information on Custom Connectors please visit: https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconnectors
For using the custom connector, please follow the next steps.
a. Get your API Key from the Clockify app. https://clockify.me/user/settings
b. Download the .mez file from here: https://github.com/OscarValerock/Clockify-PowerBI/raw/master/Clockify.mez
c. Save the .mez file in the folder shown below: C:\Users{Username}\Documents\Power BI Desktop\Custom Connectors
d. Open Power BI Desktop and in the Get Data window search for the "Clockify" connector; when connecting you will be asked to enter the key.
e. If you need to schedule refresh the dataset/report, you will need to do it through a gateway, you can find more information in the following link. https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors
2. Clockify template
For using the template (pbit) file, please follow the next steps:
a. Get your API Key from the Clockify app. https://clockify.me/user/settings
b. Download the pbit file from the link below: https://github.com/OscarValerock/Clockify-PowerBI/raw/master/Clockify-PBI-Template-PBIT/Clockify%20v2.10.pbit
c. Open the file, you will be asked for the API Key and a Page Size, for the
Page Size parameter leave in 500, this is mostly important for the
Time Entries Table.
Detailed Report Start year and Detailed Report Start year parameters, use the desired range of years.
2.1 Clockify template for self hosted Clockify users
Self-hosted Clockify users, you will need to open the template and go through every query and in the advanced editor and change the URL to your server connection detail where you have Clockify installed, it is the same URL that you use to log in.
--