This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 85%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Hello,
I am working on a chatbot using OpenAI service and my custom data, which is in an Excel file. The data contains state and district names.
I created an index on Cognitive search and used that index on chat playground. I added a system message and tried to query the chatbot, "How many districts are there in a particular state?". However, it is not performing calculations on all the districts.
What can I do to resolve this issue?
Hi Arpit
Firstly you'll need to ensure that your data is structured and indexed properly for the chatbot to understand and respond correctly. if you have structured it already.
attach a screenshot of the exact error and the team will look into it,
thanks much.
Yes, I have indexed it properly.
Firstly I made an index on Cognitive search and uploaded the data after that I used that index for the chatbot.
I have district column in my data, I am asking for total unique districts and it is unable to answer.
I
Attaching the screenshots.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 60%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Hi Arpit Verma,
Please GitHub account link https://github.com/NikhilSehgal123/Azure-OpenAI-SQL for connecting Azure OpenAI service with SQL and detailed step by step guide.
Detailed Video is there https://www.youtube.com/watch?v=_VKMToxWv4E
I hope the solution is useful to you and then accept the answer.
Regards,
Janarthanan S
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
@Arpit Verma Apologies for late response here!
I reached out to Product team and as per discussion Excel is not supported now. Team is working on it and its on our roadmap, please stay tuned.