Connecting Power BI to Learn Amp API

Learn about how to connect Power BI to your Platform.

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.

Step 1: API documentation

Familiarise yourself with our API documentation. You can read this here.

Step 2: Log in to Learn Amp account

Log into your Learn Amp account as the “owner” user.

Open

Step 3: Retrieve API

Retrieve your API client id and secret, from the Company Settings → API page.

Open

Step 4: Retrieve access token

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.

Step 5: Web data source

Open Power BI and add a “Web” data source. 

Step 6: Fill in endpoint

Select "Advanced" and fill in the following for URL:

https://api.learnamp.com/v1/activities

or

https://api.learnamp.com/v1/tasks

or whichever end point you prefer.

You may also like to add additional filters, as per the API documentation.

Step 7: 

Add the following under "HTTP request header parameters"

Authorization --> Bearer YOUR-ACCESS-TOKEN

Step 8: Import data

Click "OK" to import data from the API into Power BI.