Export of time entries and show on a Dashboard in PowerBi

[JuliaMilovanov]

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]

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]

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]

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