Power BI allows you to collect and visualise any data via its business intelligence (BI) tool. This guide will demonstrate how to connect Power BI 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 a source and choose 'web'
Step 2: Choose advanced and enter the endpoint that you would like to pull from Tanda. (You need to use https in the URL). Add your header as ‘Authorization’ and the 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 for Authorization) and (lowercase b for bearer) token is correct, then choose your endpoint and click connect under anonymous.
Step 4: Otherwise, you should be taken directly to your data to do any transformations.
Step 5: You’ll notice that this user's 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 a large set of data, so 'to' and 'from' params are used in the below request example.
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.