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.

Step 3: Retrieve API

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

 

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"

Authorisation --> Bearer YOUR-ACCESS-TOKEN

 

Step 8: Import data

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

 

 

Watch our step-by-step video on setting up the Power BI tool:

Our video will take you through all the steps to help you get set up.

We recommend watching on a high definition so that the content is clear and not blurry.

richard_power_bi_video