A complete, end-to-end walkthrough, from an empty folder to a live, authenticated, database-backed web app running inside Microsoft Fabric, using Fabric Apps (Preview) and the Rayfin toolchain.

Read on to learn more about who won the first ever Fabric Ontology Innovation Contest.

At first, I thought Microsoft Fabric was just another Microsoft product.

But after learning more, I realized the real idea behind Fabric is much bigger:
bringing Data Engineering, Analytics, Data Science, and Power BI together in one unified platform.

That’s exactly what made me start creating Arabic content to simplify the learning journey for others.

🇧🇷 PT: Chegamos à reta final! Descubra como garantir um "Go-Live" sem estresse no Microsoft Fabric usando automação CI/CD, governança de dados e o checklist definitivo de prontidão para produção. Aprenda a usar a IA para revisar a segurança do seu projeto antes do lançamento.

🇺🇸 EN: We've reached the final stretch! Discover how to ensure a stress-free "Go-Live" in Microsoft Fabric using CI/CD automation, data governance, and the ultimate production readiness checklist. Learn how to use AI to review your project's security before launch.

🇪🇸 ES: ¡Llegamos a la recta final! Descubra cómo garantizar un "Go-Live" sin estrés en Microsoft Fabric utilizando automatización CI/CD, gobernanza de datos y el checklist definitivo de preparación para producción. Aprenda a usar la IA para revisar la seguridad de su proyecto antes del lanzamiento.

🇧🇷PT: Da teoria à prática: descubra como o Data Contract garante que sua IA no Microsoft Fabric trabalhe com dados limpos e precisos. Aprenda a guiar o GitHub Copilot para construir um Lakehouse blindado contra erros.

🇺🇸EN: From theory to practice: discover how the Data Contract ensures your AI in Microsoft Fabric works with clean and precise data. Learn how to guide GitHub Copilot to build a Lakehouse shielded against errors.

🇪🇸ES: De la teoría a la práctica: descubra cómo el Data Contract garantiza que su IA en Microsoft Fabric trabaje con datos limpios y precisos. Aprenda a guiar a GitHub Copilot para construir un Lakehouse blindado contra errores.

A structured look at how SQL workloads have evolved across deployment models — from on-premises SQL Server to SQL database in Microsoft Fabric — including what's Generally Available, what's in Preview, and what's coming next.

🇧🇷PT: Começar no Microsoft Fabric pode ser intimidador, mas o segredo do sucesso não está apenas na ferramenta, e sim no planejamento. Descubra como o Spec Driven Development (SDD) transforma o GitHub Copilot em seu assistente mais preciso para projetos de BI. Esta é a Parte 1 de uma trilogia dedicada a tirar você do zero com segurança e IA.

🇺🇸EN: Starting with Microsoft Fabric can be daunting, but the secret to success isn't just the tool—it's the planning. Discover how Spec Driven Development (SDD) turns GitHub Copilot into your most precise assistant for BI projects. This is Part 1 of a trilogy dedicated to getting you from zero to hero safely with AI.

🇪🇸ES: Comenzar en Microsoft Fabric puede ser intimidante, pero el secreto del éxito no está solo en la herramienta, sino en la planificación. Descubra cómo el Spec Driven Development (SDD) transforma a GitHub Copilot en su asistente más preciso para proyectos de BI. Esta es la Parte 1 de una trilogía dedicada a llevarlo de cero a la meta con seguridad e IA.

PT-BR: Guia estratégico para migrar SSIS, SSAS e SSRS para a arquitetura unificada do Microsoft Fabric.
EN: Strategic guide for migrating SSIS, SSAS, and SSRS to the unified Microsoft Fabric architecture.
ES: Guía estratégica para migrar SSIS, SSAS y SSRS a la arquitectura unificada de Microsoft Fabric.

For a long time, I used to think the main problem in data work was the lack of tools.

Every time we needed something, we just added a new tool.

Tired of managing security three different ways for SQL, Spark, and Power BI? Microsoft Fabric's OneLake Security changes the game with a single unified layer that enforces table, row, column, and folder-level access control across every engine. Define your security policies once in the portal, and they're automatically enforced whether users query through notebooks, SQL endpoints, or DirectLake reports. This blog walks you through setting up real-world demos with sample data, creating granular roles via UI clicks, and validating enforcement across engines. Ready to simplify your data security? Let's build it step-by-step.

In large restaurant chains, keeping tabs on thousands of assets equipment, inventory, purchase orders, and transfers across hundreds of locations is a significant operational challenge. When that data lives in disconnected systems, gets reported manually, and arrives 24–48 hours late, the business is always flying behind the windshield.

This post walks through how we helped Restaurant Industry Company replace a fragile, manual reporting pipeline with a fully automated Micr... , reducing data latency from 48 hours to under 3, eliminating manual reporting effort, and laying the foundation for AI driven forecasting.

In the previous blogs of this series, we explored the foundations of modern data platforms—starting with Parquet, then understanding Delta Tables, and finally looking at how Delta Live Tables automate data pipelines.

But modern analytics environments involve more than just storage formats and pipelines. Organizations also need platforms that can manage data engineering, analytics, machine learning, and reporting.

Today, three major platforms dominate this space:

• Microsoft Fabric

• Databricks

• Snowflake

Each platform provides powerful capabilities, but they are designed with different philosophies and use cases in mind.

In this article, we will explore how these platforms compare and when organizations should choose each one.

How a unified Lakehouse architecture in Microsoft Fabric improved data consolidation, reduced latency, and strengthened solar forecasting workflows.

We're pleased to announce the winner of the Fabric Extensibility Toolkit contest!

In the article, I walk through a simple, practical scenario where business users ask ad hoc questions and get instant answers without writing SQL or building new visuals.

It covers the full setup, from creating the lakehouse to publishing the data agent, along with key limitations to keep in mind.

If you are working with Microsoft Fabric or building self service analytics for business teams, this will be useful.

Microsoft Fabric is changing how we think about analytics, data engineering, and BI.
If you already work with Power BI, SQL, or Azure tools, this blog will help you understand what Fabric really is, how its components fit together, and where to start without getting overwhelmed.

In this blog, I will walk you through how to configure OneLake security with fine‑grained Read, Read‑Write access and Row‑Level Security (RLS) in Microsoft Fabric. This step‑by‑step guide is based on a real‑world scenario and includes practical implementation details that you can easily replicate in your environment.

Transitioning from Mirrored Data to a Fabric Lakehouse Without Pipelines

Want to make sense of your Microsoft Fabric spending? Discover how the Fabric Cost Analysis (FCA) solution empowers you to monitor, optimize, and clearly understand your platform costs. Developed by FinOps and Data experts, FCA offers a community-driven approach for deep financial and operational insights, robust architecture, and flexible analytics all powered by the latest Fabric capabilities. Get the clarity you need and join a growing community focused on smarter data platform management!

Compliance Without Complexity

We’re thrilled to announce our newest community challenge: the Fabric Extensibility Toolkit Contest - your chance to build innovative workload items, inspire the ecosystem, and help ignite the momentum behind Fabric extensibility.

Unleash the full potential of your Lakehouse! We show you the critical steps to deploy AI Data Agents in Microsoft Fabric—the breakthrough solution that allows anyone to talk to their data, not code it.

Struggling to automate Lakehouse and Warehouse deployments in Microsoft Fabric? Let's see how we can Automate with Azure DevOps.

I recently got a chance to explore GraphQL, it was an absolute revelation. I realized I could finally have a more elegant way to expose the clean, curated data from our new Microsoft Fabric environment to modern applications. This blog post is a summary of that journey, explaining exactly what GraphQL is, why you need it, and how it transforms data access.

In this post, we will discuss the final two configuration categories associated with Cloud Adoption Framework's Landing Zone pillars as applicable to Microsoft Fabric. This is the final post in the 3 part series I started a few months ago.

Design Area - Governance

Microsoft Fabric capacity costs are surfaced to customers using the Azure Cost Management service. This allows integration of costs into the Azure Cost Management dashboard and alerting experience. Refer to this topic on granular information on the cost meters that are available in Azure Cost Management related to Fabric

Capacity Optimization

Microsoft Fabric’s technical architecture and commercial model allow for customers to control how much capacity they consume in order to optimize operational costs. Following aspects of Capacity configuration can be leveraged. Fabric capacity monitoring is discussed in a separate section within this document.

Capacity Reservations

Microsoft Fabric offers clients the option to reserve Capacity for a period of time in exchange for discount on operational costs. Opting into reserved capacity should be done in a planned and methodical manner to ensure that the reservations result in commercial benefit. More information on Capacity Reservation can be found here.

Data Governance using Microsoft Purview

Microsoft Purview offers rich, robust, scalable and comprehensive data governance controls. Using Purview, customers are able to define and apply sensitivity labels, monitor lineage, promote/certify data items etc. Full breadth of Purview Data Governance features can be found here.

Design Area - Platform Automation and Devops

Git Integration

Microsoft Fabric’s Lifecycle management tools offers customers standardized mechanism to collaborate and communicate when working in a multi-developer environment using Fabric’s Data Science, Data Engineering, Real-time Analytics and other capabilities. Git integration and Deployment Pipelines can be leveraged to achieve automation across development and release process.

Multiple developers can simultaneously contribute to complex projects in a single Fabric Workspace if the workspace is configured to use Git. By applying Git advantages and best practices, developers can collaborate and release content changes quickly and effectively across the Workspace.

More information on Git Integration in Microsoft Fabric can be found at this page.

Deployment Pipelines

Deployment Pipelines in Microsoft Fabric enable creators to develop and test content in the service before it reaches users. Following item types are supported as of March 2025

• Activator
• Dashboard
• Data pipeline (preview)
• Dataflows gen2 (preview)
• Datamart (preview)
• Environment (preview)
• Eventhouse and KQL database
• EventStream (preview)
• KQL Queryset
• Lakehouse (preview)
• Mirrored database (preview)
• Notebook
• Org app (preview)
• Paginated report
• Power BI Dataflow
• Real-time Dashboard
• Report (based on supported semantic models)
• Semantic model (that originates from a .pbix file and isn't a PUSH dataset)
• SQL database (preview)
• Warehouse (preview)

For more information on this feature in Fabric, refer to this part of the documentation.

Platform Automation

Microsoft Fabric is supported through comprehensive REST API that allows most administrative tasks to be scripted/automated. This approach allows predictable outcome each time an operation is repeated (eg. Deploying a new data pipeline). More information on Fabric Rest API can be found here.

This concludes the series that covers Microsoft Fabric Design Guidance using Cloud Adoption Framekwork's design pillars. From the time I published the first post in this series, there have been many changes, updates and announcements and I would encourage you to review the entire Fabric roadmap for latest information. You can find this at http://aka.ms/fabricroadmap 

Links

Microsoft Fabric CAF Configuration Guide - Part 1

Microsoft Fabric CAF Configuration Guide - Part 2

In this blog, I’ll walk you through the key differences between Microsoft’s DP-600 and DP-700 certifications — helping you decide which path suits your skills, background, and career goals best.