Microsoft Fabric Updates Blog

Natural Language to Generate and Explain Pipeline Expressions with Copilot (Preview)

Say goodbye to complex syntax—Copilot now makes building pipeline expressions as easy as having a conversation. Introducing a new Copilot capability (Preview) that transforms how you create and understand pipeline expressions in Fabric Data Factory.

Why This Matters

Pipeline expressions are powerful tools for dynamic data movement and transformation. But writing them often means memorizing syntax, debugging errors, and spending time you’d rather use elsewhere. This new Copilot feature changes that by making expression building intuitive, conversational, and accessible to everyone.

Copilot Pipeline Expression Builder experience

What’s New with Pipeline Expression Builder Copilot?

You’ll find Copilot built right into the Pipeline Expression Builder, so you can chat with it just like you do with other Data Factory Copilot experiences.

Here’s what you can do:

1. Generate Expressions Using Natural Language: Instead of writing complex syntax, simply describe what you need.

‘Get the current date in UTC.‘
‘Add 7 days to the pipeline start time.‘

Copilot instantly translates your intent into accurate pipeline expressions—no guesswork required.

Generate expression skill in Copilot — The following prompt was used in this Copilot example: Get the current date and time in UTC. Convert the current UTC time to Central Standard Time (CST). Format the converted CST time into a string like 2025/07/10. Finally, concatenate the string ‘ContosoSales\’ with the formatted date.

With Copilot, you’re always in control! You can choose to Accept, Discard, or even retry a prompt. If you Accept the prompt, Copilot will replace the contents in the expression builder with the generated content.

Accepted content gets generated into the expression builder.

2. Explain Existing Expressions in Plain Language: Ever looked at an expression and thought, ‘What does this even do?’. Now, you can ask Copilot to explain it in clear, contextual terms.

No more decoding syntax—just clarity.

Explain expression skill in Pipeline Copilot

Why You’ll Love it

Boost productivity: Reduce manual coding and speed up pipeline development.
Minimize errors: Let Copilot handle syntax so you can focus on logic.
Empower everyone: Whether you’re a seasoned developer or new to Data Factory, this feature makes expression building approachable.

How it Works

1. Open the Pipeline expression builder in your pipeline activity. You can navigate to the Pipeline expression builder; select view in expression builder or add dynamic content in your activity.