How does Fabric Data Agent works

Hi Jeanxyz, you need to "teach" your agent how to correctly query your data. You need to provide instructions, that combine sample questions with the sample queries. You need to explain, precisely, in the instructions how to find "most profitable products". You can write it in plain language, or provide a sample query.
When you test your query, you can see how the model decided to construct a query. You can compare that query with your correct one and see the difference. And, again, as many concrete instructions as you can add to the instructions, as better your Data Agent will be answering.

Hope this helps. If you din this answer useful, please consider giving kudos and accept as a solution.