How does Fabric Data Agent works

Hi Jean,

Great question , and you’re absolutely right to look deeper here, because what you’re seeing isn’t just coming from your explicit instructions.

What’s happening is that the Fabric Data Agent doesn’t rely only on your prompt or example queries. It also uses an internal interpretation layer that combines:

• Your natural language question
• The semantic model / Lakehouse schema
• Column metadata (names, relationships, measures)
• Built-in reasoning heuristics for generating “useful” queries

That’s why your question:
“most profitable products in 2024”

is being expanded into something like:

• ProductName
• Category
• Brand
• Additional metrics

Even though you didn’t explicitly define those , the agent is auto-expanding the query based on available dimensions in the model, trying to provide a richer breakdown.

So to answer your key question:

The generated text is coming from the LLM + semantic model inference layer, not directly from your agent instructions.