awork-io / awork

The awork Github repo supports you with awork integration and api questions. Here you can find links to further documentation, a FAQ with the most frequently asked questions and great code examples to get started even faster.
https://www.awork.com
11 stars 0 forks source link

Export of time entries and show on a Dashboard in PowerBi #127

Open JuliaMilovanov opened 1 year ago

JuliaMilovanov commented 1 year ago

What is your question?

Hi guys We would like to export timeentries automatically and finally present them on a seperate dashboard like PowerBi. The reason lies with additional calculations (e.g. calculation of overtime, breaks but also turnover vs. capacity). We thought about storing them in Azure Storage on which PowerBI has access to. We already made some trials via Automation Feature and request of "webhooks". Please could you assist on finding the best way for it or maybe you have another ideas for such a reporting?

Thank you in advance

BR Julia

Do you have a trace id of the call?

No response

nilzzzzzz commented 1 year ago

Hi @JuliaMilovanov ,

there are multiple ways that are possible. It depends a bit on your development capabilities.

So if you are trying to build a no code solution for that, i think the easiest way would be with tools like make.com build an integration which puts the data to powerbi when time entries have been created or updated.

If you are able to do a bit of scripting, you could write code in the PowerBI language "M" which is fetching all timeentries every day.

What could be also a way is to use our google sheets integration and pull the timeentries and then make your calculations on top of that.

Are those directions helping or can you be more specific how i can assist you? ;)

Best

Nils

JuliaMilovanov commented 1 year ago

Hi Nils,

Thank you for your quick reply. Is there any possibility to use excel as source for the pull job of timeentries?

Actually, we need assistance in creation of an API connection. Maybe-a documentation which we can follow to create one in order to use the idea, I mentionned above.

Thank you in advance

VG Julia

timkley commented 1 year ago

@JuliaMilovanov my agency provides support for things like this. If that's of interest to you may send me some way to contact you :)