Please use the following steps to connect Power BI Desktop to the Learn Amp API.
You can also watch our step-by-step video at the end of the page.
Familiarise yourself with our API documentation. You can read this here.
Log into your Learn Amp account as the “owner” user.
Retrieve your API client id and secret, from the Company Settings → API page.
Use a rest client tool, to retrieve your access token. This is described in our API documentation here.
We recommend Postman or Advanced Rest Client for this.
Open Power BI and add a “Web” data source.
Select "Advanced" and fill in the following for URL:
or whichever end point you prefer.
You may also like to add additional filters, as per the API documentation.
Add the following under "HTTP request header parameters"
Authorization --> Bearer YOUR-ACCESS-TOKEN
Click "OK" to import data from the API into Power BI.