AI-powered development with Fabric Data Factory – ingest, transform and understand your data with Copilot
The new Copilot capabilities of Fabric Data Factory to efficiently ingest your data, easily apply transformation with natural language and understand your data with Copilot explanation.
In September 2024, we made Copilot for Data Factory generally available, new features are rolling out to make your data experience even more powerful and intuitive. In this blog, discover 5 innovative Copilot features designed to boost productivity for Data Factory.
Copilot in Modern Get Data in Dataflow Gen2 (Preview)
Copilot in MGD in Fabric Dataflow Gen2 empowers you to ingest and transform data effortlessly with natural language commands. Discover a faster, smarter way to get the data you need.
- Easily ingest data from your recently used tables by choosing from the recent tables list,
- Chat with your data to apply transformations to find the data you want.
Get Data Copilot in Dataflow Gen2 (Generally Available)
Efficiently connecting to your data is important. With the power of new get data Copilot capability supported in Dataflow Gen2, users can quickly connect to existing resources or set up new connections with ease.
- Quickly connect to existing data resources by typing the existing connection name in natural language, then preview your data before loading.
- Easily create a new connection by describing your requirements, and Copilot will guide you through a filtered get data wizard or a prefilled connection creation page to set up.
You can learn more in the Streamline Data Source Setup with Copilot’s New ‘Get Data’ Capability documentation.
Natural Language to Custom Column Copilot (Generally Available)
This Copilot will be a revolutionary update to the custom column experience! With the new copilot experience inside the custom column dialog, you’ll find a special input textbox marked with the Copilot icon, ready to turn your descriptions into actionable formulas:
- Simply generate the custom column by describing the logic you need for your column.
- Save your time and effort because Copilot interprets these instructions and instantly generates the formula.
To learn more details, refer to the NL to Custom Column Copilot in Dataflow Gen2 documentation.
Explain Dataflow Copilot (Generally Available)
AI-powered assistant within Dataflow Gen2 that helps you interpret Mashup (Power Query M) code in natural language.
- Efficiently apply the Copilot summary into each query and step description to better document the power query for others to easily understand.
- Efficiently use Copilot’s clear explanations as documentation for each query and step, making Power Query straightforward for all users.
To learn more, refer to the Copilot explainer skill in Dataflow Gen2 documentation.
Explain Pipeline Copilot (Generally Available)
AI-powered assistant within Data pipeline helps you to easily understand each pipeline and activity functionality with natural language.
- Easily understand pipelines with structured detailed insights into the activities based on their orchestration, and with handy links to directly connect the summary to detailed activity information.
- Easily update pipeline and activity descriptions using Copilot’s concise summaries.
To learn more, refer to the Explain and document pipeline with Copilot documentation.
Learn more about Copilot for Data Factory
Copilot for Data Factory (Generally Available)
AI-powered development with Data Factory Microsoft Fabric
