Power BI allows you to collect and visualize any data via its business intelligence (BI) tool. This guide will demonstrate how to connect PowerBI to Workforce.com's API so that you can start importing data.
Pulling data into Power BI using Workforce.com'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 Workforce.com. (you need to use https in the URL). Add your header as ‘Authorization’ and value of ‘bearer’ + your token from Workforce.com. You can create a new API token in Workforce.com 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 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 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 Workforce.com
You can embed your Power BI report back into Workforce.com, to be available via the Reports dropdown, or on your dashboard.