Clockify Dashboard

[joepaulkjohn]

Would really appreciate if someone can share how to link powerbi with Clockify data and then use that to create dashboards

[NicoT]

Thought I'd share my findings as I noticed a reply or two asking for info on linking Clockify.

I came across Tugger, who provide a connector allowing me to get my data into Power PI, just by using an OData link, completely avoiding having to mess with the Clockify API.

Incidentally, I signed up for a 30 day free trial (https://tuggerapp.com); this also includes a report template, even during the free trial.

This OData link provides a user name and password so my data is nice and secure. It is very simple to use in Power BI as I can map the tables in the Model section as needed.

Although, I've actually started using the Power BI report template they include; they are apparently fine with their customers altering the template. I suppose I will alter it, just to make it more in keeping with the others I use.

[MFelix]

Hi @joepaulkjohn ,

Check this blog post that presents shows a PBIX file connected to Clockify, and an explanation on how to connect.

https://medium.com/@OscarValerock/clockify-power-bi-template-589001f732b8

[Lucas_Villamor]

Hi MFelix! 

That post worked for me too, temporarily (https://github.com/OscarValerock/Clockify-PowerBI). The second optioin did actually, the custom connector never did. However, we´ve now upgraded to clockify ProPlan, which includes more modules, such as expenses, time-off, etc. Those new modules do not appear now in Power BI. 

Do you happen to have any solution? 

Thanks! 

[NathaliaGuedes]

Boa tarde! 

Esse mesmo erro acontece comigo!
Há alguma atualização de como vincular o PowerBI com o Clockify?

[joepaulkjohn]

@MFelix. Thanks for the article shared. This was an article I had used earlier and attempted to connect. I have tried it again but am regularly getting the below error. FYI I have used the V1 file in the folder.

Appreciate the help

[MFelix]

Hi @joepaulkjohn ,

What type of sign in did you used? I tried to do it with the anonymous and it connected.

(have a bunch of all other errors but not related with login)

[joepaulkjohn]

Yes, it was anonymous that i had used. I just tried the same on V3 also. But the same error.