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.
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:
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"
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.