Reporting - Dataset mapping schemas

*** Please note, this article refers to Reporting and Analytics with Power BI. View the FAQ for more details. ***

In this article, we'll show the expected file outputs when you export Power BI datasets to an external SFTP location. We'll also provide the mapping schema for all exportable datasets so you can join data tables within a single dataset (or across multiple datasets) in any way that works best for your external reporting tools.

Learn - Accreditations dataset

Expected file outputs - 10 files:

Mapping schema:

Learn - Courses, Catalogues, and Lessons Administration dataset

Expected files outputs - 8 files:

Mapping schema:

Learn - CPD dataset

Expected file outputs - 12 files:

Mapping schema:

Learn - Evaluations dataset

Expected file outputs - 13 files:

Mapping schema:

Learn - Events dataset

Expected file outputs - 12 files:

Mapping schema:

Learn - Learning Progress dataset

Expected file outputs - 14 files:

Mapping schema:

Learn - Lesson History dataset

Expected file outputs - 13 files:

Mapping schema:

Learn - SCORM dataset

Expected file outputs - 9 files:

Mapping schema:

Learn - Users, Groups, and Sign-in History dataset

Expected file outputs - 8 files:

Mapping schema:

Learn - User Imports dataset

Expected file outputs - 3 files:

Mapping schema:

Perform - Development Activities dataset

Expected file outputs - 5 files:

Mapping schema:

Perform - Feedback dataset

Expected file outputs - 4 files:

Mapping schema:

Perform - Objectives dataset

Expected file outputs - 6 files:

Mapping schema:

Perform - Reviews dataset

Expected file outputs - 11 files:

Mapping schema:

Discover more about reporting with Power BI

Looking for quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. 

If you're new to reporting with Power BI, Reporting and analytics 101 introduces the fundamentals to help you get started. For a deeper dive, the short Academy Course Five must-know features explores these key topics in more detail and serves as the starting point for the Get Started: Reporting and analytics with Power BI course. 

You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.