Skip to content
Tutorials and sample code for integrating CDM folders with Azure Data Services
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Initial commit Nov 28, 2018
AzureDataFactory edited default parameter values Dec 8, 2018
AzureDatabricks Changed comments to encourage use of secret-scope Jan 4, 2019
AzureMachineLearning Tutorial pdf, markdown & images Dec 10, 2018
AzureSqlDataWarehouse update WWI-Sales.sql with calendardate dimension Dec 10, 2018
CDM Porting latest Python updates from CDM repo Jan 16, 2019
Tutorial updated location of source code for Scala lib used in Databricks section Jan 23, 2019
.gitignore Initial commit Nov 28, 2018 Updates to readme and tutorial to reference blog post Dec 14, 2018

CDM folders and Azure Data Services integration

Tutorial and sample code for integrating Power BI dataflows and Azure Data Services using Common Data Model (CDM) folders in Azure Data Lake Storage Gen2. For more information on the scenario, see this blog post.


The tutorial walks through use of CDM folders in a modern data warehouse scenario. In it you will:

  • Configure your Power BI account to save Power BI dataflows as CDM folders in ADLS Gen2;
  • Create a Power BI dataflow by ingesting order data from the Wide World Importers sample database and save it as a CDM folder;
  • Use an Azure Databricks notebook that prepares and cleanses the data in the CDM folder, and then writes the updated data to a new CDM folder in ADLS Gen2;
  • Use Azure Machine Learning to train and publish a model using data from the CDM folder;
  • Use an Azure Data Factory pipeline to load data from the CDM folder into staging tables in Azure SQL Data Warehouse and then invoke stored procedures that transform the data into a dimensional model;
  • Use Azure Data Factory to orchestrate the overall process and monitor execution.

Each step leverages metadata contained in the CDM folder to make it easier and simpler to accomplish the task.

The provided samples include code, libraries, and Azure resource templates that you can use with CDM folders you create from your own data.

IMPORTANT: the sample code is provided as-is with no warranties and is intended for learning purposes only.

Getting Started

See the tutorial for pre-requisites and installation details.


The sample code and tutorials in this project are licensed under the MIT license. See the LICENSE file for more details.


This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact with any additional questions or comments.

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.