Excel converted to PDF retrieval inaccurate

[bp3000bp]

Please provide us with the following information:

This issue is for a: (mark with an x)

- [x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

I took an Excel sheet with tables of several hundred employees contact information, and then converted that Excel sheet into a PDF to be uploaded to the data folder. The retrieval with this PDF file is extremely unreliable. I am wondering if uploading the excel sheet itself would make the responses any more accurate, or if this is an issue that is happening because of the amount of information that is stored in this one document. It is frustrating when you ask the bot, "what is the contact info for _______" and despite it being clearly listed in the PDF, the bot cannot come up with an accurate answer. How can I address this?

Any log messages given by the failure

n/a

Expected/desired behavior

Give the correct contact information

OS and Version?

windows 11

azd version?

azd version 1.9.6 (commit 0b1a8ad350177078312141f4465ad72205d7c077)

Versions

n/a

Mention any other details that might be useful

---

Thanks! We'll be in touch soon.