topic AI prompt column in Dataflow Gen2 in Data Engineering

AI prompt column in Dataflow Gen2

kye1crystal — Tue, 02 Dec 2025 01:01:27 GMT

Hi guys, I got a task that utilizing AI(LLM) to create new columns base on existed columns. So I would like to use DFG2 new function - AI prompt column in Dataflow Gen2 reffer to https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-ai-functions

Following the instruction to enable the settings, but still can't see the bottom in DFG2.

It should be :

Re: AI prompt column in Dataflow Gen2

lbendlin — Tue, 02 Dec 2025 01:41:52 GMT

Did you

"Enable "Allow combining data from multiple sources" in the Privacy section of the Options dialog to use this feature with other data sources."

Re: AI prompt column in Dataflow Gen2

kye1crystal — Tue, 02 Dec 2025 01:52:24 GMT

Hi lbendlin ,
I check Options and found I have enabled.

Re: AI prompt column in Dataflow Gen2

kye1crystal — Tue, 02 Dec 2025 04:15:01 GMT

Please help

Re: AI prompt column in Dataflow Gen2

AntoineW — Wed, 03 Dec 2025 10:49:20 GMT

Hi kye1crystal,

I understand the frustration, it is confusing when documentation describes a feature that doesn't appear in the interface. Since the AI Prompt Column is a very new feature (announced at Microsoft Ignite 2025 recently), the issue is likely due to the deployment schedule or a specific tenant setting.

If you cannot wait for the UI rollout, you can achieve the exact same result (using LLMs to enrich columns) using Fabric Notebooks right now.

You can use the AI function or standard OpenAI calls within PySpark or Pandas to transform your data.

Reference : https://learn.microsoft.com/en-us/fabric/data-science/ai-functions/overview?tabs=pandas-pyspark%2Cpandas

Hope it can help you!

Best regards,

Antoine

Re: AI prompt column in Dataflow Gen2

kye1crystal — Thu, 04 Dec 2025 01:25:21 GMT

Hi AntoineW ,
Thanks , help me a lot. I am Looking forward to the new function.