Microsoft Fabric Blog presents an in-depth look at new Copilot-powered features in Fabric Data Factory, showing how AI enhances data ingestion, transformation, and understanding. Authored by the Microsoft Fabric Blog team.

AI-Powered Development with Fabric Data Factory – Ingest, Transform, and Understand Your Data with Copilot

Author: Microsoft Fabric Blog

The Microsoft Fabric team introduces powerful new Copilot capabilities for Data Factory, designed to make data engineering and analytics easier and more productive. These AI-driven features are generally available as of September 2024, with rolling updates adding even more transformative tools.

Key Copilot Features in Fabric Data Factory

1. Copilot in Modern Get Data (Dataflow Gen2 – Preview)

  • Effortlessly ingest data using natural language commands.
  • Quickly select data from recent tables or chat with your data to apply desired transformations.

2. Get Data Copilot (Dataflow Gen2 – Generally Available)

  • Connect to existing data resources by typing connection names in natural language.
  • Create new data connections by simply describing your requirements—the Copilot helps configure or prefill connection setups.
  • Learn more

3. Natural Language to Custom Column Copilot (Generally Available)

  • Generate custom columns by explaining logic in plain English.
  • Copilot converts descriptions into actionable formulas, saving time and reducing manual errors.
  • Full details

4. Explain Dataflow Copilot (Generally Available)

  • Interpret Mashup (Power Query M) code via natural language explanations.
  • Copilot generates clear summaries and documentation for queries and steps in Power Query.
  • Documentation

5. Explain Pipeline Copilot (Generally Available)

  • Provides detailed, structured summaries of each pipeline and its activities in natural language.
  • Quickly update activity descriptions and connect summaries to in-depth documentation.
  • More info

Learn More and Get Started

Conclusion

With these new Copilot features, Fabric Data Factory brings true AI-powered advances to data engineering, making complex data ingestion, transformation, and documentation far more accessible and efficient. Users can interact with their data estates using natural language and receive actionable insights and automations instantly.

This post appeared first on “Microsoft Fabric Blog”. Read the entire article here