Microsoft Fabric Updates Blog

User Data Functions now support async functions and pandas DataFrame, Series types

Microsoft Fabric has introduced new features for its User Data Functions (UDFs), enhancing Python-based data processing capabilities within the platform. These updates include support for asynchronous functions and the use of pandas DataFrame and Series types for input and output, enabling more efficient handling of large-scale data. • Async function support: Developers can now write async functions in Fabric UDFs to improve responsiveness and efficiency, especially for managing high volumes of I/O-bound operations, such as reading files asynchronously from a Lakehouse. • Pandas DataFrame and Series integration: UDFs can accept and return pandas DataFrames and Series, allowing batch processing of rows with improved speed and performance in data analysis tasks. An example function calculates total revenue by driver using pandas groupby operations. • Usage in notebooks: These functions can be invoked directly from notebooks using pandas objects, facilitating efficient aggregation and analysis of large datasets interactively within Microsoft Fabric. • Getting started and benefits: Users can enable these features by updating the fabric-user-data-functions library to version 1.0.0. The enhancements reduce I/O operations, enable concurrent task handling, and improve performance on datasets with millions of rows.

Announcing new features for Microsoft Fabric Extension in VS Code

The Microsoft Fabric Extension for VS Code introduces two new features that enhance the management of Fabric items directly within the editor. Users can now perform CRUD operations on Fabric items and switch between multiple tenants easily. These updates aim to improve workflow efficiency and are based on customer feedback, inviting further suggestions for enhancement.

How to debug user data functions locally in VS Code

Debugging your code is a big deal, especially when you’re working with user data functions. You want to make sure everything works as it should and that’s where local debugging lets you catch problems in your code without messing with the live environment. In this blog post, I’ll walk you through the steps to make local debugging easier, faster, and less of a headache.

Query vs. Mutation in API for GraphQL – Understanding the difference

GraphQL has revolutionized the way developers interact with APIs by offering a more flexible and efficient alternative to REST. Before getting started , Create an API for GraphQL in Fabric and add data to use GraphQL in Fabric. At the heart of GraphQL are two core operations: queries and mutations. While they may look similar on the surface, they serve very different purposes. Let’s explain it in detail.

Service principal and private library support for Fabric User data functions

Using Service Principal and Managed Identity, along with private libraries for Fabric user data functions, makes working with data much easier and more secure. These features let developers customize workflows and use their own code to solve problems, boosting productivity and creativity in teams. As businesses grow and rely more on unique analytics and automation, these tools help simplify data management and improve operations. Check this blog post to learn more