Overview This lab demonstrates how to implement comprehensive security measures in a Microsoft Fabric data warehouse, including dynamic data masking, row-level security, column-level security, and granular SQL permissions. Prerequisites Lab Steps 1. Create Workspace and Data Warehouse 2. Implement Dynamic Data Masking — Create table with masked columns CREATE TABLE dbo.Customers ( CustomerID INT NOT… READ MORE
In today’s data-driven world, organizations need the ability to analyze and act on data as it flows in real time. Microsoft Fabric provides a powerful ecosystem for real-time intelligence, enabling businesses to process, store, analyze, and visualize data with minimal latency. In this blog I will introduce you to the key components that make real-time… READ MORE
Are you trying to create tables from queries in the new Microsoft #fabric #sql environment and wondering why CREATE TABLE AS doesn’t work? You’re not alone! In this video, we’ll explore the right way to do this in Fabric SQL — using the powerful SELECT INTO statement. ✅ Whether you’re building a data warehouse or… READ MORE
In the ever-evolving landscape of data management, organizations face the challenge of selecting the most suitable storage strategy for their data. Two prominent options are data lakes and data warehouses, each with its unique strengths and weaknesses. This blog explores these storage solutions in-depth, delving into technical details to help you make an informed decision… READ MORE
We are excited to announce the preview of Fabric User Data Functions! This feature is made to empower developers to create functions that contain their business logic and connect to Fabric data sources, and/or invoke them from other Fabric items such as Data pipelines, Notebooks and Power BI reports. Fabric User Data Functions leverage the Python… READ MORE
#powerbi + Microsoft #Fabric: What Report Authors Need to Know In this video, Manuel Quintana breaks down how Power BI works with Microsoft Fabric—without changing how you build reports. What’s Covered: – What Fabric is and why it matters – #OneLake & #Dataflows Gen2 – Connecting to #Lakehouses & #SemanticModels – Direct Lake mode benefits… READ MORE
It’s no surprise to data enthusiasts that Microsoft Fabric is shaping the future of data platforms. This powerful tool is not only popular but also dramatically shifting market dynamics. In this article, we will explore the out-of-the-box features of Microsoft Fabric that help you seamlessly integrate your data into OneLake. The Power of OneLake Imagine OneLake as… READ MORE
Are you interested in exploring Microsoft Fabric? Then this article is for you. Microsoft Fabric is an end-to-end analytics platform that allows you to perform data ingestion, transformation, processing real-time analytics, and dashboard reporting. It encompasses data engineering, data science, and Data analytics bringing unified solutions for enterprises. The aim of this Microsoft Fabric Project… READ MORE
During Microsoft Fabric project implementations, I’m frequently asked a deceptively simple question: “Under which identity is this running?” It turns out, the answer isn’t always straightforward – and to be honest, it’s a topic I’ve also found quite complex at times. Just because a schedule was created by you doesn’t necessarily mean the entire job triggered by… READ MORE
Microsoft Fabric continues to shape the future of data analytics with a comprehensive plan designed to unify and streamline your data ecosystem. This latest update outlines a structured roadmap with clearly defined milestones that will empower organizations to extract actionable insights with unprecedented speed and efficiency. The Plan at a Glance The Microsoft Fabric plan… READ MORE
