The Data Lake connection method provides the simplest and most powerful way to connect Power BI to your Learn Amp data. Using our AWS Redshift data warehouse, you get direct access to a comprehensive, analytics-optimised data schema—without the complexity of API calls or pagination handling.

💡 Tip: This method is available to customers with the Data Lake bolt-on or Advanced Analytics package. Contact your Customer Success Manager to enable access.

For full details on what the Data Lake offers and how it works, see Our Data Lake and Warehouse Explained.

This is a provisioned service—there are no in-app settings to configure.

Before connecting Power BI, you'll need Data Lake access set up. Follow our comprehensive guide:

Getting Started with Data Lake

This guide covers:

• Requesting access from your CSM

• IP whitelisting requirements

• Receiving your credentials

• Network configuration requirements

Once you have your Data Lake credentials (from the setup guide above), follow these Power BI-specific steps:

1. Launch Power BI Desktop

2. Click Get Data from the Home ribbon

3. Search for Amazon Redshift

4. Click Connect

Use the credentials provided by your CSM:

1. Server: bi.la-dl.com:5439

2. Database: Your database name (e.g., prod_eu1)

3. Click OK

1. Select Database authentication method

2. Enter your provided username and password

3. Click Connect

1. In the Navigator pane, expand your schema (your subdomain name)

2. Select the tables you need for your report

3. Click Load to import directly, or Transform Data to shape the data first

💡 Tip: Start with the activities and users tables for a basic learning progress report.

For a complete list of all tables and fields available in the Data Lake, see:

Data LakeHouse: Data Schema

Key tables for Power BI reports include:

⚠️ Note: The Data Lake includes data for deactivated users and archived content. Remember to filter these out if appropriate for your reports.

How do I get Data Lake access?

See Getting Started with Data Lake for the complete setup process.

Where can I find the full data schema?

See Data LakeHouse: Data Schema for all available tables and fields.

Can I schedule automatic refreshes in Power BI Service?

Yes! Once published to Power BI Service, you can configure scheduled refresh. You'll need an on-premises data gateway—see Power BI Gateway Configuration for setup instructions.

How often is the data updated?

The Data Lake refreshes hourly through our ETL pipeline. See Our Data Lake and Warehouse Explained for more details.

For Data Lake access issues, see Getting Started with Data Lake.

• Review the Data LakeHouse: Data Schema for available tables

• Set up Power BI Gateway Configuration for scheduled refresh

• Contact Customer Support if you encounter any issues