Forum Discussion

ahaggin's avatar
ahaggin
Occasional Reader
Aug 07, 2026

Snippet Files Truncating Data - Excel

Dear community, 

 

Background

I am looking for feedback regarding a best practice for using Microsoft Excel files as a knowledge source. My data is structured in a tabular format, stored across 3-4 columns in Excel (~500 rows, one sheet). For context, it is a simple mapping file that can be used to query about team responsibilities and who to contact for a specific topic/region/etc. I use this file in parallel with Outlook and Teams tools to escalate topics directly to individuals. I have a skill already created (contacts-responsibilities) that very clearly details the file and how the Agent should behave. 

Issue

In the "developer" preview, I can see the Agent is identifying the correct knowledge source, but the processing technique is resulting in truncated snippet files. After multiple fail-retry loops, the Agent concludes that the data is not present in the file (which it most certainly is). Here are some of the notes the Agent returns: 

  • "the snippet seems to be limited to a certain portion of the file"
  • "the search result only returned partial data from the spreadsheet."

Ask

Any suggestions on what exactly to do here? I have read that issues should only occur when you hit 1500+ rows of data. I could split my data apart, but this would mean more maintenance on my side. Thank you! Any hint is appreciated. 

 

 

No RepliesBe the first to reply