How to set up the Sparkle Cronos Timesheet solution?

What is it?

Power BI Connector and premade report to the Cronos Timesheet APP (TIA)

How to set it up?

1. Get a Power BI PRO subscription.

In Cronos group you can acquire it by emailing the service desk: servicedesk@cronos.be

2. Get the API and access keys

Send an email to Tia Support: tia-support@cronos.be.

You must be a TIA admin user for your company.

3. Install the power bi application from Microsoft AppSource and connect

Press connect your data. The credentials you have received from Tia Support.

Who does what and where?

 TIA API credentials (receive from TIA Support):
  • tia_Username

  • tia_Password

  • tia_X-Apikey

Parameters:

  • periodstart: the startdate of which you want to get data. With filling in the date parameters, please note that your local language settings determine the format.

  • periodend: the enddate to which you want to get data

  • company_id: the id of the company for which you want the data. The company_id you can also receive from Tia Support if you don’t know it. If you would like to use the app for multiple companies, then it is possible to fill a list of multiple company id’s, with a comma seperator.

 

Main financial measures 

In the advanced section you can specify if you want to refresh the dataset daily

Press then next and fill the azure function authentication.

Azure function authentication (receive from TIA Support):

  • user name

  • password

Once you are connected you can use the app.
The app will install a power bi dataset and a report. You can update your parameters in the settings section of the dataset and then refresh.

  1. Use the app and share it with your co-workers or customers

The API credentials are safely stored in the dataset.

You can make your own adaptation of the report with specific filters (e.g. a report only for a customer). You can also combine the report with your own data.

5. Questions

Please contact us through Freshdesk https://sparkle.freshdesk.com/support/login

et