🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
Guided DP-600 Domain 1
Domain 1 — Module 4 of 7 57%
4 of 29 overall

DP-600 Study Guide

Domain 1: Maintain a Data Analytics Solution

  • Workspace Access Controls
  • Row-Level & Object-Level Security
  • Sensitivity Labels & Endorsement
  • Git Version Control in Fabric
  • Deployment Pipelines: Dev → Test → Prod
  • Impact Analysis & Dependencies
  • XMLA Endpoint & Reusable Assets

Domain 2: Prepare Data

  • Microsoft Fabric: The Big Picture Free
  • Lakehouses: Your Data Foundation Free
  • Warehouses in Fabric Free
  • Choosing the Right Data Store Free
  • Data Connections & OneLake Catalog
  • Shortcuts & OneLake Integration
  • Ingesting Data: Dataflows Gen2 & Pipelines
  • Star Schema Design Free
  • SQL Objects: Views, Functions & Stored Procedures
  • Transforming Data: Reshape & Enrich
  • Data Quality & Cleansing
  • Querying with SQL
  • Querying with KQL
  • Querying with DAX

Domain 3: Implement and Manage Semantic Models

  • Semantic Models: Storage Modes
  • Relationships & Advanced Modeling
  • DAX Essentials: Variables & Functions
  • Calculation Groups & Field Parameters
  • Large Models & Composite Models
  • Direct Lake Mode
  • DAX Performance Optimization
  • Incremental Refresh

DP-600 Study Guide

Domain 1: Maintain a Data Analytics Solution

  • Workspace Access Controls
  • Row-Level & Object-Level Security
  • Sensitivity Labels & Endorsement
  • Git Version Control in Fabric
  • Deployment Pipelines: Dev → Test → Prod
  • Impact Analysis & Dependencies
  • XMLA Endpoint & Reusable Assets

Domain 2: Prepare Data

  • Microsoft Fabric: The Big Picture Free
  • Lakehouses: Your Data Foundation Free
  • Warehouses in Fabric Free
  • Choosing the Right Data Store Free
  • Data Connections & OneLake Catalog
  • Shortcuts & OneLake Integration
  • Ingesting Data: Dataflows Gen2 & Pipelines
  • Star Schema Design Free
  • SQL Objects: Views, Functions & Stored Procedures
  • Transforming Data: Reshape & Enrich
  • Data Quality & Cleansing
  • Querying with SQL
  • Querying with KQL
  • Querying with DAX

Domain 3: Implement and Manage Semantic Models

  • Semantic Models: Storage Modes
  • Relationships & Advanced Modeling
  • DAX Essentials: Variables & Functions
  • Calculation Groups & Field Parameters
  • Large Models & Composite Models
  • Direct Lake Mode
  • DAX Performance Optimization
  • Incremental Refresh
Domain 1: Maintain a Data Analytics Solution Premium ⏱ ~13 min read

Git Version Control in Fabric

Track every change. Git integration for workspaces, .pbip projects, and collaborative analytics development.

Version control for analytics

☕ Simple explanation

Git is like a save-point system in a video game. Every change creates a save point (commit). If something breaks, go back. If two people change things at once, Git merges them.

Fabric Git integration connects a workspace to a Git repo. Changes sync both ways.

Fabric Git integration connects a workspace to an Azure DevOps or GitHub branch. Items are serialised as text files. The .pbip format (Power BI Project) enables Git-friendly diffs for semantic models and reports.

Setting up Git integration

  1. Workspace Settings → Git integration
  2. Choose provider (Azure DevOps or GitHub)
  3. Select repo and branch
  4. Connect — items sync to the repo

.pbip vs .pbix

.pbip enables Git workflows .pbix cannot
Feature.pbix.pbip
FormatSingle binary fileFolder with text files (JSON, TMDL)
Git-friendly?No — binary diffs meaninglessYes — clean text diffs
CollaborationOne person at a timeMultiple people, different files
Code reviewNot possiblePR reviews on individual changes
💡 Exam tip: TMDL

.pbip uses TMDL (Tabular Model Definition Language) for semantic model definitions. Changes to individual tables, measures, or relationships produce clean text diffs. TMDL files can be edited outside Power BI Desktop.

Question

What does Fabric Git integration do?

Click or press Enter to reveal answer

Answer

Connects a workspace to a Git repo. Items are serialised as files. Enables version history, branching, PRs, and rollback.

Click to flip back
Question

What is .pbip format?

Click or press Enter to reveal answer

Answer

Power BI Project — folder-based format replacing .pbix for Git. Contains text files (JSON, TMDL) for meaningful diffs and collaboration.

Click to flip back
Knowledge Check

James wants Git collaboration on a semantic model currently in .pbix. What first?
Question

Which Fabric items sync to Git, and which do not?

Click or press Enter to reveal answer

Answer

Items that sync: semantic models, reports, paginated reports, and notebooks (serialised as text files). Items that do NOT sync: dashboards, lakehouses (data files), warehouses (data), dataflows, pipelines. Only item definitions (metadata) sync — not the underlying data.

Click to flip back
Knowledge Check

James connects a production workspace to the main branch in Git. A consultant commits a semantic model change to a feature branch. What must happen before the change appears in the production workspace?

🎬 Video coming soon

Next up: Deployment Pipelines

← Previous

Sensitivity Labels & Endorsement

Next →

Deployment Pipelines: Dev → Test → Prod

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.