Announcing the General Availability of Copilot for Data Factory in Microsoft Fabric
Copilot for Data Factory with Dataflow Gen 2 is now generally available, an experience that is part of the Copilot in Fabric, where you can use natural language to transform data and generates code explanations to help you better understand previously generated queries and tasks.
Copilot in Fabric helps you enhance productivity, unlock profound insights, and facilitate the creation of custom AI experiences tailored to your data. As a component of the Copilot in Fabric experience, Copilot for Data Factory empowers you to use natural language to articulate your requirements for creating data integration solutions using Dataflow Gen2. Essentially, Copilot for Data Factory operates like a subject-matter expert (SME) collaborating with you to design your dataflows.
Copilot for Data Factory, a trusted subject-matter expert, by your side, to help you with Dataflow
Dataflows in Fabric Data Factory provides you with a low-code interface to ingest data from hundreds of data sources, transforming your data using 300+ data transformations.
Dataflows are built with the familiar Power Query experience to empower you, no matter if you are a citizen or professional data integrators, to perform data tasks such as joins, aggregations, data cleansing, custom transformations, and much more.
Once Copilot is enabled in Fabric, Copilot for Data Factory will also be available by your side as a subject matter expert (SME) to help you with Dataflows. Whether you need to create a new query, add a step to an existing query, or help you understand a complex query, Copilot for Data Factory can help. All you need to do is ask!
Copilot for Data Factory can help you create a query in Dataflow
If you want to create a query with data within a brand-new Dataflows in Fabric Data Factory, or simply just want to add a new query to an existing Dataflows, Copilot can intelligently understand what you need and create a new query per your requirements.
Adding a new step is just as simple with Copilot for Data Factory
With a query already in place within Dataflows, you can simply add a step to add a column, filter rows, and much more by asking your Copilot for Data Factory SME to do that for you.
Sometimes a query can be complex, but that’s OK – your Copilot for Data Factory is here to help
Not all queries are simple. With complex queries, especially those that are built by someone else and shared with you, you might need help to understand what is inside the query with a simple explanation. This is where Copilot for Data Factory can shine and provide you with a simple explanation which will help you understand the complexity.
Copilot for Data Factory Availability
Today, you can leverage Copilot for Data Factory to help you be more productive with Dataflows to perform data transformation tasks. It is like having a trusted SME by your side to help you accelerate your development of Dataflows. Together with all the experiences with Copilot in Fabric, we aim to help you unlock the full potential of your data.
We love to learn about your ideas. if you have an idea or would like to help us prioritize upcoming features for Copilot for Data Factory, please add an idea here.
Stay tuned to our Copilot for Data Factory roadmap for new feature updates.
