Cheat Sheets

Microsoft Fabric Cheat Sheet

Quick reference for Microsoft Fabric — from OneLake and Data Factory to Lakehouses, Warehouses, Real-Time Analytics, Power BI integration, and governance.

SQL Python Power BI DAX M Code Microsoft Fabric Snowflake Databricks Git VS Code Vim Homebrew HTML CSS3 JSON Java JavaScript AI Prompts Markdown Data Warehouse

Ingest. Engineer. Analyze. Govern.

Tap for definition · Hold to copyHover for definition · Click to copy

Core Components

Microsoft FabricOneLakeLakehouseWarehouseData FactoryReal-Time AnalyticsPower BI

Workspaces & Storage

WorkspaceCapacityShortcutsDelta TablesFiles SectionTables Section

Data Engineering

NotebookApache SparkPySparkDataFrameSave as TableSemantic Link

Data Factory & Pipelines

PipelineCopy ActivityDataflow Gen2Schedule PipelineParametersMonitor Hub

SQL & Warehousing

SQL EndpointT-SQLStored ProcedureViewCTASStar Schema

Real-Time Analytics

EventstreamKQL DatabaseKusto Query Language (KQL)Real-Time DashboardStreaming Data

Power BI Integration

Semantic ModelDirect LakeImport ModeDAXReportDashboard

Security & Governance

Microsoft PurviewRow-Level Security (RLS)Sensitivity LabelsData LineageWorkspace Roles

Best Practices

Use Medallion ArchitectureOptimize Delta TablesSeparate Storage & ComputePrefer Direct LakeImplement Naming Standards