Microsoft Fabric
From Raw Data to a Delta Table in Microsoft Fabric: A Practical PySpark Walkthrough
Learn how to define a PySpark schema, create a sales DataFrame, and write it as a Delta table in a Microsoft Fabric Lakehouse.
Loading
Ways to Load Data into a Microsoft Fabric Lakehouse: Upload Files
Learn how to upload local files to a Microsoft Fabric Lakehouse, store them in OneLake, and load CSV data into Delta tables for analysis.
Materialized Lake Views in Microsoft Fabric
Learn how Microsoft Fabric Materialized Lake Views materialize Lakehouse transformations, optimize refreshes, enforce data quality, and support medallion architecture pipelines.
Sharing a Lakehouse in Microsoft Fabric
Learn how to share a Microsoft Fabric Lakehouse, assign read, SQL, and Spark permissions, and manage user access without granting workspace access.
Creating a Fabric Capacity from Fabric Capacity Monitoring
Learn how to create a Microsoft Fabric capacity from the Manage Capacities page in the Monitor hub, including configuration options, permissions, and provisioning steps.
New Fabric Capacity Monitoring in Microsoft Fabric
Learn how to use Microsoft Fabric Capacity Monitoring to review capacity health, CU utilisation, throttling, SKUs, regions, and capacity management options.
Integrating JSON Data into a Fabric Lakehouse Using Dataflow Gen2
In this article, I walk through the exact steps I used to integrate a JSON sales file into a Microsoft Fabric Lakehouse using Dataflow Gen2 — from connecting to the JSON source and expanding its nested structure, to fixing data types, mapping the output to a Lakehouse table, and publishing the dataflow for a clean, queryable result.
Lakehouse Schemas in Microsoft Fabric: Creating Sales and Marketing Tables Using Fabric Notebook
In this article, we explored how to create Sales and Marketing schemas in a Microsoft Fabric Lakehouse and use a Fabric Notebook to create and write tables into their respective schemas. The demonstration used PySpark to create sample data and save it as Delta tables.
Azure AI Search OneLake Indexer: Building RAG Pipelines from Microsoft Fabric Data
Learn how to use the Azure AI Search OneLake indexer to build RAG pipelines from Microsoft Fabric data, including indexing and retrieval architecture.
Reassigning a Workspace in the Microsoft Fabric Admin Portal
Learn how to reassign an existing Power BI Pro workspace to a Fabric Capacity directly from the Microsoft Fabric Admin Portal
Microsoft Fabric Admin Portal: A Practical Guide for Fabric Administrators
A practical introduction to the Microsoft Fabric Admin Portal, covering tenant settings, capacity management, domains, monitoring, governance, security, and the difference between tenant-level and workspace administration.
Switching Lakehouses in a Microsoft Fabric Notebook
In my latest article, I demonstrate how to connect multiple Lakehouses to a Fabric Notebook and switch between them when needed, using Sales and Marketing Lakehouses as an example. A simple but useful feature for Fabric data engineers and developers.
OneLake ≠ Lakehouse: Understanding the Foundation of Microsoft Fabric
Understand the difference between Microsoft Fabric OneLake and Lakehouse, including how they work together for unified storage, data engineering, Delta tables, Spark, SQL, and analytics.
Building Tenant-Aware AI Knowledge Layers with Microsoft Foundry IQ
Build tenant-aware AI knowledge layers with Microsoft Foundry IQ while enforcing tenant isolation, access controls, source filtering, permissions, and secure enterprise knowledge retrieval.
Benchmarking AI Retrieval Latency Across Fabric IQ and Vector Stores
Benchmark AI retrieval latency across Microsoft Fabric IQ and traditional vector stores by comparing response times, retrieval accuracy, indexing performance, scalability, and enterprise workload behavior.
Switching Query Results in Fabric Warehouse
Learn how to run multiple SELECT statements in a Microsoft Fabric Warehouse and easily switch between their individual result sets. Using practical examples with Region, Product, and Orders tables, this article shows how multiple queries can simplify data exploration, validation, troubleshooting, and everyday SQL development in Fabric.
Calculate the Number of Days Between Order Date and Ship Date in Fabric Dataflow Gen2
Learn to calculate shipping days in Fabric Dataflow Gen2 using Power Query. Handle date types, missing values, and invalid dates for robust data transformation.
Building Enterprise AI Usage Analytics with Microsoft Fabric and Power BI
Unlock enterprise AI insights with Microsoft Fabric & Power BI. Monitor adoption, optimize costs, and enhance governance for AI usage analytics.
How Zero-Copy Access Between Microsoft Fabric OneLake and Azure Databricks Changes Modern Data Engineering
Unlock modern data engineering with zero-copy access between Microsoft Fabric OneLake & Azure Databricks. Reduce costs, simplify architecture, and ensure data consistency.
Understanding Microsoft Fabric: 5 Core Concepts Every Data Engineer Should Know
Unlock Microsoft Fabric's power! Understand its unified platform, OneLake, Delta Tables, Lakehouse, and Direct Lake for data engineers.
Building Enterprise AI Audit Trails with Microsoft Fabric
Build robust enterprise AI audit trails with Microsoft Fabric. Ensure compliance, track lineage, and gain real-time insights into AI operations.
Programmatically Create a Lakehouse from a Microsoft Fabric Notebook
Automate Microsoft Fabric Lakehouse creation using Python notebooks and notebookutils. Streamline deployments, provision environments, and integrate with CI/CD.
Choosing Between Lakehouse and Warehouse in Microsoft Fabric: A Real-World Project Walkthrough
Reasons for choosing the lakehouse and warehouse in end to end fabric pipline
Understanding SHOWPLAN_ALL in SQL Server and Microsoft Fabric
In this article, you'll learn hoe to master SQL Server's SHOWPLAN_ALL for query optimization. Understand execution plans, avoid pitfalls, and tune for peak performance.
Understanding Eventstream in Microsoft Fabric: From Streaming Data to Real-Time Intelligence
Unlock real-time intelligence with Microsoft Fabric's Eventstream. Ingest, transform, and route streaming data instantly for immediate insights and action.
Loading Files into an Existing Fabric Lakehouse Table Using the Graphical User Interface (GUI)
In this article, you will learn how to load files to Fabric Lakehouse tables using existing table append behaviour of the graphical user interface
Microsoft Fabric Update: You Can Now Adjust Column Width in the SQL Analytics Endpoint User Interface
This article is about the new feature in Microsoft Fabric that allows you to adjust column width
Using the COPY INTO Command to Load Data from Fabric Lakehouse to Fabric Warehouse
In this article, I demonstrated how to use the COPY INTO Command to Load Data from Microsoft Fabric Lakehouse to Fabric Warehouse
Extracting ZIP Files in Microsoft Fabric Lakehouse Using Fabric Notebook
Learn how to extract ZIP files directly within Microsoft Fabric Lakehouse using a Fabric Notebook, Python, and PySpark. Automate data ingestion and streamline ETL pipelines.
Integrating Salesforce Data into Microsoft Fabric Using Dataflow Gen2
Learn how to seamlessly integrate Salesforce data into Microsoft Fabric using Dataflow Gen2. Unlock insights with a low-code approach for analytics & reporting.
