topic Re: Data Agent Example Queries in Data Engineering

Data Agent Example Queries

RaajPritvi26 — Mon, 12 Jan 2026 14:41:36 GMT

Hello everyone,

While creating a data agent in Fabric, I added some SQL queries as direction for the agent. While doing it manually, I noticed that everytime I added a query, the agent will proceed to validate all the queries including the ones that were already validated. Is there a way to disable this?

Also, I tried uploading JSON files as the example queries, however the validating never stopped. Not sure whats the issue there.

Anyone have any ideas how to resolve the above two?

Re: Data Agent Example Queries

ssrithar — Mon, 12 Jan 2026 14:00:53 GMT

Hi @RaajPritvi26

Great question — both of these are known limitations in the current Fabric Data Agent experience.

There is currently no way to disable this behavior.

Suggested Workaround:

Keep each query simple and modular during build/test
Paste in pre-validated SQL (run in Fabric Warehouse first)

JSON Upload Hangs During Validation

Why This Happens:

The agent expects a very specific JSON structure
Any deviation (invalid syntax, missing fields, extra commas, bad escaping) can cause validation to hang or silently fail
Complex SQL strings with newline characters or quotes can also trip up the parser

How to Fix It:

Start with a minimal valid JSON template
Avoid complex formatting in the query string
Validate the JSON before uploading
Upload a few queries at a time to isolate errors
Improve error handling for bad JSON (e.g., show validation error instead of silent loop)
Support bulk editing with syntax highlighting in the agent editor

If this post helps, then please appreciate giving a Kudos or accepting as a Solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Data Agent Example Queries

RaajPritvi26 — Mon, 12 Jan 2026 15:04:52 GMT

Hi @ssrithar

Thanks! Appreciate your insights! Another thing that came across my mind is that is there a max number of example queries we can input into the data agent? I played around and noticed anything above 100 will also result in the perpetual validation issue.

Re: Data Agent Example Queries

apturlov — Mon, 12 Jan 2026 15:41:08 GMT

@ssrithar I am not an expert in how this is done in Fabric, but I wanted to mention that the Data Agent instructions become part of the context during the chat. The larger the instruction the larger the context the more tokens it consumes during the chats. That will be eating the Fabric Capacity faster. I would suggest there should be a balance between how compex the instructions are and the goal of what you are trying to achive with the agent. I would try and match the instructions set with the main case scenario of this agent intended usage.

Re: Data Agent Example Queries

v-dineshya — Wed, 14 Jan 2026 10:38:03 GMT

Hi @RaajPritvi26 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @ssrithar and @apturlov , Thank you for your prompt responses.

Hi @RaajPritvi26 ,

The agent only uses the top four most relevant examples at runtime, but it does not define an upper storage limit. Even the UI currently struggles with large sets. The validator re-checks the entire set every time an example is added or changed. Large sets increase validation load significantly.

Note: 20–40 well‑crafted examples per domain confirmed to work reliably across creators. Avoid attempts to upload >100 until Microsoft improves validation performance. The agent makes use of only a handful during execution, so massive libraries provide minimal additional benefit but large authoring overhead.

Please refer below links.

Data Agent Example Queries - Microsoft Fabric | Microsoft Learn

Creator Improvements in the Data Agent | Microsoft Fabric Blog | Microsoft Fabric

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Re: Data Agent Example Queries

v-dineshya — Mon, 19 Jan 2026 10:32:53 GMT

Hi @RaajPritvi26 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

Re: Data Agent Example Queries

v-dineshya — Fri, 23 Jan 2026 03:46:27 GMT

Hi @RaajPritvi26 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh