Hello @yvesbeutler ,
AI/BI Genie selects relevant names and descriptions from annotated tables and columns to convert natural language questions to an equivalent SQL query. Then, it responds with the generated query and results table, if possible. If Genie can't generate an answer, it can ask follow-up questions to clarify before providing a response.
I am sharing official documentation for your reference: https://learn.microsoft.com/en-us/azure/databricks/genie/#overview
You can follow below instructions/best practice that you can use to achieve this:
1.) You can add instructions along these lines E.g. ask users to clarify words like effective, best, etc which are relevant to their query.
2.) You can also add the general instructions like: "If the user asks vague or unclear questions, ask for follow-up clarifications before generating results."
3.)After following what is mentioned in 2. if still Genie continues to directly generate results. Once it generates the results, you can click on "Fix it" and then provide the exact same instruction again and see if that helps.
I hope this helps!