Microsoft Fabric Updates Blog

Enhance data prep with AI-powered capabilities in Data Wrangler

All Fabric notebook users have access to Data Wrangler, a code-generating tool with an immersive interface for exploring and transforming pandas or Spark DataFrames. Data Wrangler provides a library of common data-cleaning operations that you can browse and apply seamlessly, getting real-time previews and generating reusable code. 

Thanks to new AI-powered capabilities in Data Wrangler, including automated suggestions and custom operations with Copilot, you can now do even more to accelerate exploratory analysis and data preparation in Fabric. 

Get automated suggestions with rule-based AI 

Unsure where to start? A new set of automated suggestions analyzes your data with rule-based AI from the Microsoft PROSE team, highlighting the most relevant Data Wrangler operations for you. Every time you apply a new operation, the suggestions refresh based on the new state of your data. 

New AI-powered suggestions highlight Data Wrangler operations that are relevant to you.

Ask Copilot to apply custom operations 

Need an operation that you don’t see in Data Wrangler? You can now use Copilot to generate custom code. All you need to do is describe the desired operation. As with any Data Wrangler step, you get a preview before applying or discarding the code.  

With Copilot in Data Wrangler, you can generate custom code from your own instructions.

Translate custom code from pandas to PySpark

Working on big data? Data Wrangler converts Spark DataFrames to pandas for performance reasons, then translates all exported code back to PySpark. With GenAI in Data Wrangler, custom code is also translated to PySpark—whether you type it in yourself or generate it with Copilot. 

Data Wrangler can translate all your operations from pandas to PySpark, using AI where necessary to produce the most accurate code.

Next steps

We’re eager for you to try out the new capabilities in Data Wrangler and let us know what you think.

  • If you’re interested in using Data Wrangler to apply the new set of Fabric AI functions—for tasks like sentiment analysis, entity extraction, and custom text generation—sign up for the preview experience with this link: aka.ms/DataWranglerAIPreview

Related blog posts

Enhance data prep with AI-powered capabilities in Data Wrangler

June 12, 2025 by RK Iyer

Introduction Whether you’re building analytics pipelines or conversational AI systems, the risk of exposing sensitive data is real. AI models trained on unfiltered datasets can inadvertently memorize and regurgitate PII, leading to compliance violations and reputational damage. This blog explores how to build scalable, secure, and compliant data workflows using PySpark, Microsoft Presidio, and Faker—covering … Continue reading “Privacy by Design: PII Detection and Anonymization with PySpark on Microsoft Fabric”

June 11, 2025 by Eren Orbey

Earlier this year, we released AI functions in public preview, allowing Fabric customers to apply LLM-powered transformations to OneLake data simply and seamlessly, in a single line of code. Since then, we’ve continued iterating on AI functions in response to your feedback. Let’s explore the latest updates, which make AI functions more powerful, more cost-effective, … Continue reading “Introducing upgrades to AI functions for better performance—and lower costs”