🧩 CI/CD Tutorials — Cycle 1

Exploring version control, deployment automation, and DevOps workflows in Microsoft Fabric.
(🟢 = completed | ⚪ = in progress)

CD001 ⚪ Git Repository Setup

Set up version control in Microsoft Fabric using either GitHub or Azure DevOps.  Connect a Fabric Workspace to a Git repository, enable tenant permissions, and explore authentication using a user account vs. Service Principal for automation.

• Focus: Building a foundation for version control and understanding CI/CD strategy.

CD002 ⚪ Deployment Pipeline Setup

Create a three-stage deployment pipeline (DEV → TEST → PROD).  Configure Fabric Workspaces for a structured workflow that separates testing and production environments.

• Focus: Establishing disciplined deployment stages for safe, iterative releases.

CD003 ⚪ Pipelines and Version Control

Test how Fabric Pipelines commit to Git and how configuration changes appear in version control.
Observe how schedules, parameters, and activities affect deployment behavior.

• Focus: Seeing firsthand that “if it doesn’t get committed, it doesn’t get deployed.”

CD004 ⚪ Notebooks

Explore how Fabric Notebooks interact with version control — from code cells and Lakehouse connections to scheduling.
Compare what deploys between environments and what stays local.

•  Focus: Understanding the nuances of version control in hybrid data-science workflows.

CD005 ⚪ Power BI Projects (PBIP)

Work with semantic models using TMDL and TMSL formats.
Compare Power BI Desktop vs. in-service development, and version-control Power BI assets through VS Code.

• Focus: Transitioning from PBIX to PBIP for collaborative, text-based development.

CD006 ⚪ Data Warehouse

Bring schemas, tables, and stored procedures into version control.
Track structural changes through Git and explore what deploys cleanly vs. what causes conflicts.

• Focus: Applying CI/CD discipline to data-store structures.

CD007 ⚪ Lakehouse

Test Lakehouse deployment and version control features still in Public Preview.
Create tables, rename objects, and add shortcuts to evaluate sync behavior.

• Focus: Moving toward Infrastructure-as-Code principles for Lakehouse initialization.

CD008 ⚪ Item Pairing

Understand how Fabric pairs items across DEV, TEST, and PROD.
Experiment with renames and code edits to see how pairing impacts deployment.

• Focus: Visualizing and managing item relationships through the deployment pipeline.

CD009 ⚪ Deployment Rules

Configure Deployment Rules to dynamically adjust parameters or connections between environments.
Compare traditional rules with the new Variable Libraries feature.

• Focus: Exploring evolving options for environment-specific configurations.

CD010 ⚪ Metadata-Driven Pipeline Deployment

Design a metadata-driven data pipeline using dynamic Warehouse connections and Pipeline IDs.
Use JSON-based configuration to adapt pipelines automatically across environments.

• Focus: Building flexible, metadata-aware pipelines for real-world CI/CD.

CD011 ⚪ Data Warehouse SQL Project (DACPAC)

Use VS Code and SQL Database Projects to manage Warehouse objects locally, build DACPACs, and deploy them into Fabric.
Compare manual SQL editing with automated deployment artifacts.

• Focus: Establishing code-based deployment for Data Warehouse automation.

CD012 ⚪ Branches and Policies

Implement Git branching strategies and branch policies in Azure DevOps.
Create feature branches, manage pull requests, and protect the main branch.

• Focus: Practicing collaborative development and change control within CI/CD.