Microsoft Fabric Updates Blog

From Simple Prompts to Complex Insights: AI Expands the Boundaries of Data Transformation (Preview)

Data Factory

In today’s fast-paced business environment, efficiency, and adaptability are essential. Organizations are under constant pressure to streamline processes, reduce complexity, and deliver results faster. Dataflow Gen2 rises to meet these challenges by combining the power of Artificial Intelligence (AI) with the simplicity of natural language prompts. This approach enables teams to transform workflows and unlock insights without the need for complex coding.

Screenshot of AI Prompt entry in the Add column tab of the Power Query editor ribbon

Why Dataflow Gen2 Matters

Dataflow Gen2 represents a significant step forward integrating AI into everyday operations. By blending prompt-driven automation with enterprise-grade data integration, it empowers teams to:

Automate Repetitive Tasks: Apply AI-powered transformations like summarization, classification, translation, and sentiment analysis within dataflows—no manual coding required.
Personalize at Scale: Outputs are context-aware based on the data passed from within your Dataflow.
Collaborate Seamlessly: Integration with Microsoft Fabric ensures a unified experience across data engineering, data factory, and analytics workloads, reducing friction and accelerating productivity.

The Future of Work is Here

The combination of AI-powered automation, simple prompts, and enterprise-grade data integration is redefining productivity. With Dataflow Gen2, teams can start small—experiment with a few workflows—and quickly scale to transform entire processes. This is the simplicity and intelligence that unlocks new levels of efficiency and creativity.

You can find this new preview feature within the Add column tab of the ribbon in Dataflow Gen2 with the name AI Prompt. In the AI Prompt dialog, you can now pass a prompt and select which columns from your table to pass as added context: