Microsoft Fabric Updates Blog

Automate Fabric Data Warehouse Queries and Commands with Data Factory

Microsoft Fabric provides a cloud-scale data warehouse to store your analytical data for dashboards and historical reporting. In Fabric Data Factory, there are a number of ways to query data, retrieve data, and execute commands from your warehouse using pipeline activities that can then be easily automated for unattended background execution. I’ll go left-to-right from … Continue reading “Automate Fabric Data Warehouse Queries and Commands with Data Factory”

Use Fabric Data Factory Data Pipelines to Orchestrate Notebook-based Workflows

Microsoft Fabric Data Factory’s data pipelines enable data engineers to build complex workflows that can orchestrate many different types of data processing, data movement, data transformation, and other activity types. In this post, I want to focus on some good practices when building Fabric Spark Notebook workflows using Data Factory in Fabric with data pipelines. … Continue reading “Use Fabric Data Factory Data Pipelines to Orchestrate Notebook-based Workflows”

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”

Integrate your SAP data into Microsoft Fabric

SAP systems hold some of the most valuable data of many enterprises, large or small. Whether it is operational data in ERP systems like SAP ECC or SAP S/4HANA, data from SAP’s data warehouse suite of products like SAP BW or SAP Datasphere, or data from SAP’s SaaS solutions – a comprehensive view on the … Continue reading “Integrate your SAP data into Microsoft Fabric”

Microsoft Fabric November 2023 update

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 … Continue reading “Microsoft Fabric November 2023 update”