Microsoft Fabric Updates Blog

Shortcut transformations: Turn files into Delta tables without pipelines (Generally Available)

Organizations today manage data across multiple storage systems, often in formats like CSV, Parquet, and JSON. While this data is readily available, turning it into analytics-ready tables typically requires building and maintaining complex ETL pipelines. Shortcut transformations remove that complexity. With Shortcut transformations, you can convert structured files referenced through OneLake shortcuts into Delta tables … Continue reading “Shortcut transformations: Turn files into Delta tables without pipelines (Generally Available)”

Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)

Fabric Data Warehouse now supports the ANY_VALUE() aggregate, making it easier to write readable, efficient T-SQL when you want to group by a key but still return descriptive columns that are functionally the same for every row in the group. What is ANY_VALUE()? ANY_VALUE() is an aggregate or analytic function that returns an arbitrary value … Continue reading “Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)”

Update on User Experience Feedback from the Reddit Thread (General Available)

Over the past few weeks, we’ve been actively reading through comments in the Reddit thread to gather UX feedback. Thank you all for taking the time to share your experiences — we appreciate your honesty and passion. Here’s a quick update on where things stand: Item dropdown no longer goes off-screen Several users noted that … Continue reading “Update on User Experience Feedback from the Reddit Thread (General Available)”

Microsoft ADO.NET Driver for Microsoft Fabric Data Engineering (Preview)

ADO.NET is a widely adopted data access technology in the .NET ecosystem that enables applications to connect to and work with data from databases and big data platforms. The Microsoft ADO.NET Driver for Fabric Data Engineering lets you connect, query, and manage Spark workloads in Microsoft Fabric with the reliability and simplicity of standard ADO.NET … Continue reading “Microsoft ADO.NET Driver for Microsoft Fabric Data Engineering (Preview)”

Announcing the latest innovations in Fabric Data Factory: Apache Airflow jobs and pipelines

Introduction The world of data integration is rapidly evolving, and staying up to date with the latest technologies is crucial for organizations seeking to make the most of their data assets. Available now are the newest innovations in Fabric Data Factory pipelines and Apache Airflow job orchestration, designed to empower data engineers, architects, and analytics … Continue reading “Announcing the latest innovations in Fabric Data Factory: Apache Airflow jobs and pipelines”