Microsoft Fabric Updates Blog

Lakehouse vs Data Warehouse vs Real-Time Analytics/KQL Database: Deep Dive into Use Cases, Differences, and Architecture Designs

With the general availability of Microsoft Fabric this past Ignite, there are a lot of questions centered around the functionality of each component but more importantly, what architecture designs and solutions are best for analytics in Fabric. Specifically, how your data estate for analytics data warehousing/reporting will change or differ from existing designs and how to choose the right path moving forward. This article will be focused on helping you understand the differences between the Data Warehouse and Data Lakehouse, Fabric solution designs, warehouse/lakehouse use cases, and to get the best of both Data Warehouse and Data Lakehouse.

Working with OneLake using Azure Storage Explorer

In today’s data-driven world, organizations face the challenge of efficiently managing and analyzing vast amounts of data. Microsoft OneLake provides a comprehensive solution that simplifies data lake management, enabling organizations to unlock valuable insights and maximize the potential of their data. To simplify interaction, OneLake seamlessly integrates with various tools and services covering a wide …

Continue reading “Working with OneLake using Azure Storage Explorer”

Announcing: Automatic Log Checkpointing for Fabric Warehouse

We are excited to announce automatic log checkpointing for Data Warehouses! One of our goals with the Data Warehouse is automate as much as possible to make it easier and cheaper for you to build and use them. This means you will be spending your time on adding and gaining insights from your data instead …

Continue reading “Announcing: Automatic Log Checkpointing for Fabric Warehouse”

Read data from Delta Lake tables with the DeltaLake.Table M function

We’re happy to announce a new function in Power Query’s M language for reading data from Delta Lake tables: the DeltaLake.Table function. This function is now available in Power Query in Power BI Desktop and in Dataflows Gen1 and Gen2 and replaces the need to use community-developed solutions like this one by Gerhard Brueckl. Let’s …

Continue reading “Read data from Delta Lake tables with the DeltaLake.Table M function”

Fabric Change the Game: Real – time Analytics

As we delve into this comprehensive series on Fabric, one of its pivotal facets we explore is Real-Time Analytics. Within this subject, Real-Time Analytics serves as a formidable tool, diminishing complexity and streamlining data integration processes. Imagine scenarios where a continuous stream of data unfolds, capturing the intricacies of messages posted on a micro-blogging site …

Continue reading “Fabric Change the Game: Real – time Analytics”