Reporting - Dataset mapping schemas

*** Please note, this article refers to the All-new Reporting and Analytics. 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 - Events dataset

Expected file outputs - 12 files:

Mapping schema:

Learn - Learning Progress dataset

Expected file outputs - 14 files:

Mapping schema:

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

Expected file outputs - 8 files:

Mapping schema:

Perform - Objectives dataset

Expected file outputs - 6 files:

Mapping schema:

Perform - Reviews dataset

Expected file outputs - 11 files:

Mapping schema:

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

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