Fabric

Like many I am also playing with Fabric, many of my clients are also excited about Fabric and want to know more about it. Being a solution architect in the…

Have you heard about the new kid in town – Microsoft Fabric? In public preview since May 2023 (Microsoft Build) we had some time to play with it and build our first projects based on this new…

The landscape of business operations is undergoing a seismic shift, driven by the advent of advanced data platforms. Microsoft Fabric is at the forefront of this transformation, heralding a new […]

As part of Microsoft Fabric, we have new Gen2 Dataflows and they have a new ability. A Gen2 Dataflow entity can have a destination, eg a table

As we embark on our quest to unravel the mysteries of the data within Fabric, a world of possibilities awaits. Let’s continue our journey in understanding and exploring the data. In this installment, our attention is directed to how to explore the functional dependencies -relationships between columns in a table. With a specific focus on … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-changing-the-game-validate-dependencies-with-semantic-link/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Changing the game: Validate dependencies with Semantic Link – Data Quality”</span></a>

Using a combination of Notebook and Data Wrangler means we can transform data and write to table writing very little code by hand.

Learn about the Version and source control in Microsoft Fabric in Power BI through an example and learn how it is done in real world scenario

Microsoft Fabric is now generally available! Fabric brings together the best of Microsoft Power BI, Azure Synapse Analytics, and Azure Data Factory into a single software as a service (SAAS) platform. Fabric provides multiple workloads purpose-built for specific personas and specific tasks. Keep reading to learn about all of Fabric’s workloads! Synapse Data Warehouse We … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-workloads-are-now-generally-available/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric workloads are now generally available!”</span></a>

We are thrilled to announce the general availability of Microsoft Fabric and the public preview of Copilot in Microsoft Fabric, including the experience for Power BI. With the launch of these next-generation analytics tools, you can empower your data teams to more easily scale to meet the demand of the business. You can create a well-orchestrated data estate that minimizes data fragmentation and makes it easy for business users to find continually up-to-date, accurate data. And it even enables business users to explore and consume governed data, helping them answer questions on their own.

Learn about two key concepts that balance your Fabric capacity workload, and how to save the money along the way!

Now that we know all the pricing details for Microsoft Fabric, let's examine what are our options to save some money in the wallet

Microsoft Graph is the gateway to data and intelligence in Microsoft 365. It provides a unified model to access the tremendous amount of data in Microsoft 365 including Teams, Outlook, SharePoint, Viva Insights, and more. Use the wealth of data in Microsoft Graph to build forward looking business insights to unlock insights on customer relationships, … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-microsoft-365-data-better-together/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric + Microsoft 365 Data: Better Together “</span></a>

As mentioned in Arun’s blog post, we are thrilled to announce that Mirroring in Microsoft Fabric is coming soon. In today’s AI driven world, analytics platforms are only as good as their data. With the ever-increasing amount of data being collected in various applications, databases, and data warehouses in an enterprise, managing and ingesting data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-mirroring-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Mirroring in Microsoft Fabric”</span></a>

Earlier this year, at Microsoft Build, we introduced, in Public Preview, Microsoft Fabric, “the biggest data product announcement since SQL Server”. Today, we are announcing the General Availability of Microsoft Fabric. Arun explains in detail why we all believe Microsoft Fabric will redefine the current analytics landscape. I will focus here on what it means … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-explained-for-existing-synapse-users/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric, explained for existing Synapse users”</span></a>

Welcome to the November 2023 update.   We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic model scale-out, and many more. Continue reading for more details on our new features!    Contents Core Microsoft Fabric User API Power BI Reporting Button … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-november-2023-update/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric November 2023 update”</span></a>

In a dynamic data engineering scenario, Sam, a skilled professional, adeptly navigates urgent requests using Microsoft Fabric. Collaborating with Data Steward Lisa and leveraging OneLake, Sam streamlines data processes, creating a powerful collaboration between engineering and stewardship. With precision in Azure Data Factory and collaboration with a Data Scientist, Sam crafts a robust schema, leading to a visually appealing Power BI report.

In the fast-paced world of data analytics, real-time insights are the driving force behind informed decisions and competitive advantage. The long-awaited moment is here: Real-Time Analytics in Microsoft Fabric has reached general availability (GA), unveiling a wide range of transformative features and capabilities to empower data-driven professionals across diverse domains. Whether you’re an experienced business … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-general-availability-explore-the-capabilities-of-real-time-analytics-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing General Availability: Explore the Capabilities of Real-Time Analytics in Microsoft Fabric”</span></a>

At Microsoft Ignite this year, we were thrilled to announce the General Availability of Eventstream. One of the exciting features is Eventstream’s real-time processing tailored for seamless integration with the KQL Database. This feature ensures a smooth experience for ingesting and transforming data streams into your KQL table. In this blog post, we’ll dive into … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/explore-data-transformation-in-eventstream-for-kql-database-integration/" class="more-link">Continue reading<span class="screen-reader-text"> “Explore Data Transformation in Eventstream for KQL Database Integration”</span></a>

I’ve been experimenting with the functionality of Microsoft Fabric and wanted to share a few things I’m using in Notebooks that help manage the wider Power BI estate. The first step to …

Great Expectations Open Source(GX OSS) is a popular Python library that provides a framework for describing and validating the acceptable state of data. It helps data engineers and data scientists ensure that their data meets specific quality standards before using it for analysis, machine learning, or other data-driven tasks. With the recent integration of Microsoft … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/semantic-link-data-validation-using-great-expectations/" class="more-link">Continue reading<span class="screen-reader-text"> “Semantic Link: Data validation using Great Expectations”</span></a>

Why? Everyone is getting a bit excited about Microsoft Fabric, and it’s not even in GA yet. I help run the Birmingham Power BI User Group, and have been asked a few questions about the impact…

CSV files are widely used for data exchange and data ingestion into data warehouses, but they often pose challenges on performance. In accordance to a study from Microsoft Research, up to 90% of the total time spent in data ingestion occurs in parsing non-binary data such as JSON when using conventional file parsers. This is … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-improvements-to-csv-data-ingestion-in-fabric-warehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing improvements to CSV data ingestion in Synapse Data Warehouse in Microsoft Fabric”</span></a>

Microsoft Fabric is a SaaS platform that allows users to get, create, share, and visualise data using a wide set of tools. It provides a unified solution for all our data and analytics workloads, from data ingestion and transformation to data engineering, data science, data warehouse, real-time analytics, and data visualisation. In a previous blog … Continue reading Microsoft Fabric: Capacity Options and Cost Management, Part 1; The Basics

In today’s ever-evolving world of data management, security is a paramount concern for organizations. We are committed to providing our customers with robust solutions that empower them to safeguard their data effectively. That’s why we are thrilled to introduce Dynamic Data Masking (DDM) for Fabric Warehouse and SQL Endpoint in Lakehouse! What is Dynamic Data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-dynamic-data-masking-for-fabric-warehouse-and-lakehouse-sql-endpoint/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing: Dynamic Data Masking for Fabric Warehouse and Lakehouse SQL Endpoint”</span></a>

We are excited to announce that the Data Warehouse now supports sp_rename. With sp_rename, you can rename user objects like Tables, Stored Procedures, Functions etc. Here is an example of how to use sp_rename that fixes a spelling mistake for city: When you use these features, change the schema an object belongs to or drop … p class="link-more"a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-fabric-warehouse-support-for-sp_rename/" class="more-link"Continue readingspan class="screen-reader-text" “Announcing: Fabric Warehouse support for sp_rename”/span/a

How to Load data from Synapse to Fabric a step by step guide.

Unlock the Power of Reusing Your Library in the Lakehouse with This Step-by-Step Guide. Fabric provides you with different options to build your analytics solution. If you decide to use Lakehouse and code your solution with Python you may want to reuse some functions and reuse certain business logic across your code. Once your library … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-changing-the-game-using-your-own-library-with-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Changing the game: Using your own library with Microsoft Fabric”</span></a>