Power BI allows you to collect and visualise any data via its business intelligence (BI) tool. This guide will demonstrate how to connect PowerBI to Tanda's API so that you can start importing data.
Pulling data into Power BI using Tanda's API
Step 1: Start by importing data from source and choose 'web'
Step 2: Choose advanced, enter the endpoint that you would like to pull from Tanda. (you needs to use https in the URL). Add your header as ‘Authorization’ and value of ‘bearer’ + your token from Tanda. You can create a new API token in Tanda via our Developer Portal.
Step 3: Click OK. If you get directed to the following page and you have made sure your header (ensure capital A) and (lowercase b) token is correct then choose your endpoint and click connect under anonymous.
Step 4: Otherwise you should be taken directly here to your data to do any transformations.
Step 5: You’ll notice that this users endpoint is an array of objects or a list of user data which means you’ll need to click into the object you want the data from.
Step 6: You can do the same with endpoints that need params by just adding them to your URL like below. Schedules endpoint requires params to query the large set of data so I am using to and from params in the below request.
For more information on using parameters, refer to our API guide.
Embed your Power BI report back into Tanda
You can embed your Power BI report back into Tanda, to be available via the Reports dropdown, or on your dashboard.