Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

conxu-ms
Microsoft Employee
‎11-21-2025 09:30 AM

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_experienceCopilot_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_CopilotGenerate_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_builderAccepted_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_CopilotExplain_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.

View_in_expression_builderView_in_expression_builder

Add_dynamic_contentAdd_dynamic_content

2. Select the Copilot chat panel.

Inline_Copilot_chatInline_Copilot_chat

3. Type your request in natural language—Copilot will generate or explain the expression for you.

4. Insert the expression directly into your pipeline.

Try It Today

We’d love your feedback! Explore the feature and share your thoughts with us.

To learn more, refer to the Explain Pipeline Expressions with Copilot documentation.

Labels:
0