Power BI Integration

Overview

Power BI is a powerful business intelligence tool that transforms your learning data into actionable insights. Learn Amp offers two methods to connect Power BI to your learning data, depending on your subscription level.

💡 Tip: If you have access to the Advanced Analytics Data Warehouse (Data Lake bolt-on or Advanced package), we recommend using the Data Lake connection method for the simplest experience.

Functionality Breakdown

Connection Methods Comparison

Feature	Data Lake (Recommended)	API

Feature	Data Lake (Recommended)	API
Subscription Required	Advanced Analytics / Data Warehouse bolt-on	Any subscription
Setup Complexity	Simple - native PostgreSQL connector	Moderate - requires OAuth setup
Data Refresh	Hourly automatic ETL	Manual or scheduled via Power BI
Data Scope	Full data warehouse schema	Selected API endpoints
Best For	Comprehensive reporting	Ad-hoc queries, specific data needs

Available Data

Both methods provide access to:

Learning activities (completions, starts, progress)
User information and team structures
Content items and channels
Event attendance
Enrolment data

Pre-requisites

Role Requirements

Connection Method	Required Role

Connection Method	Required Role
Data Lake	Contact your Customer Success Manager for provisioning
API	Owner role required to generate API credentials

⚠️ Important: Only the account Owner can create and manage API credentials in Learn Amp.

Technical Requirements

Power BI Desktop or Power BI Service
Network access to Learn Amp services
For Data Lake: IP whitelisting may be required (up to 5 static IPs)
For API: Understanding of OAuth 2.0 authentication

Quick Start Guide

Determine your connection method
- Check if you have Advanced Analytics/Data Warehouse access
- Contact your Customer Success Manager if unsure
Choose your setup guide
- Data Lake users: See Connecting Power BI via Data Lake
- API users: See Connecting Power BI to Learn Amp API
Handle pagination (API only)
- See Handling Paginated API responses for fetching all your data
Set up scheduled refresh
- See Power BI Gateway Configuration for automatic data updates

FAQs

Which connection method should I use?

If you have access to the Advanced Analytics Data Warehouse (Data Lake), we strongly recommend using the Data Lake connection. It's simpler to set up and provides access to a comprehensive, optimised data schema. The API method is ideal if you don't have Data Warehouse access or need to query specific data in real-time.

How often is data refreshed?

Data Lake refreshes hourly through our ETL pipeline. API data is live at the time of query.

Can I use both methods?

Yes! Some customers use Data Lake for comprehensive reporting dashboards and the API for real-time widgets or specific integrations.

What if I don't have Owner access?

Contact your Learn Amp administrator to request API credentials be generated, or ask them to assign you the Owner role if appropriate.

Where can I find the data schema?

For Data Lake users, see Data LakeHouse: Data Schema for all available tables and fields.

Troubleshooting

Issue	Solution

Issue	Solution
Cannot see API settings	Ensure you have the Owner role. Contact your administrator.
Data Lake connection timeout	Check your IP is whitelisted. Submit a support request if needed.
Missing data in reports	Verify the correct date range and filters. Check user permissions.
Access token expired	Generate a new access token using your Client ID and Secret.

Power BI