From Simple Prompts to Complex Insights: AI Expands the Boundaries of Data Transformation (Preview)
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.
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:
This preview feature will start rolling out on December 15, 2025 and become globally available by December 18, 2025.
Be sure to check out the documentation on: Fabric AI Prompt in Dataflow Gen2 (Preview) – Microsoft Fabric | Microsoft Learn
