web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Improve the success ra...
Copilot Studio
Answered

Improve the success rate and speed of AI retrieval knowledge base

(0) ShareShare
ReportReport
Posted on by ZY-20030516-0 22
Hello,
 
I  I have an Excel spreadsheet as a knowledge base, which contains 150000 rows of data. AI often cannot find information from the spreadsheet and cannot provide answers. Is there any way to optimize it
Categories:
General topics
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    Pstork1 69,387 Most Valuable Professional on at
    For something that large your best way to optimize it would be to transfer it to a data source like a SharePoint list or Dataverse table. Those sources are indexed and provide faster retrieval and better filtering for the agent. 
     
    If it needs to stay in Excel then breaking it up into multiple smaller Excel files that are organized around specific topics should improve the retrieval.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 837

#2
Vish WR Profile Picture

Vish WR 294

#3
Haque Profile Picture

Haque 256

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans