Azure AI assistance Upload multiple files search issue

Hello Koteshwar , Welcome to MS Q&A

I think It seems there might be an issue with how the data from the second JSON file is being indexed or queried also you can check the query configuration to ensure that it is set up to search across all indexed files. Sometimes, the query might be limited to a specific file or index.

If still not work , please review the logs and diagnostics to identify any errors or warnings related to the indexing or querying process and share the details with us.

Kindly let us know if you have other questions/query

Thanks

Deepanshu

Hi @Koteshwara R,

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

We haven’t heard from you on the last response provided by @Deepanshukatara-6769 and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Hi @Chandra Boorla
Now able to get the data from the 2 files. I'm getting inaccurate counts when I ask for the count of records with the status "In progress." I've uploaded 20 records in JSON format, and the results I'm getting are 14 or 16. Can you help me resolve this issue?

Hi @Koteshwara R

Apologies for the delay in response from my end.

When you are trying to retrieve the data from both files, you are getting inaccurate counts for records with the status “In progress,”.

Here are some troubleshooting steps that might help you:

Data Consistency: Ensure that the status field is consistently formatted across all records. Inconsistent formatting (e.g., “in progress” vs. “In Progress”) can lead to inaccurate counts.

Query Logic: Double-check the logic used in your query to count the records. Ensure that it correctly filters records with the status “In progress.”

Data Validation: Manually validate a sample of records to ensure that the counts match the expected results. This can help identify any discrepancies in the data or query logic.

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

Hi @Koteshwara R

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.