web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio - Bot Extensibility / Bot Inconsistent response
Copilot Studio - Bot Extensibility
Unanswered

Bot Inconsistent response

(1) ShareShare
ReportReport
Posted on by Sulaimanade280 2
Hello,
I have create an AI agent to help retrieve information from Azure SQL database, of course it is a structure database with rows and columns.
The issue is: I prompt the Agent and it respond properly at times but it mostly returns response like 'The retrieved documents do not contain specific information...', whereas it sometimes respond with the correct information as contained in the database.

I connected using the SQL Authentication type during initial connection and I have also used both SQL authentication and the Microsoft Entra ID integrated authentication type at first chat.
I have used both generative AI orchestration and classic orchestration.
Kindly share any insight on how to solve this issue. Thanks in advance.
Categories:
Bot Framework
I have the same question (0)
  • Suggested answer
    Romain The Low-Code Bearded Bear Profile Picture
    Romain The Low-Code... 487 on at
    Bot Inconsistent response
    i will add some other solution to previous people who answer : 
     
    I suggest you to create virtual table on dataverse or use dataflow to load you data in dataverse : why ?
     
    Because dataverse Search have received a lot of big update and it s very awesome and easy to use, just connect the dataverse MCP connector as datasource.
  • lbendlin Profile Picture
    lbendlin 8,144 Super User 2025 Season 2 on at
    Bot Inconsistent response
    What is your issue? That the responses are not consistent?  AI models do not guarantee a consistent response.  Consider using prompt engineering to assist the model for a more useful response, but that doesn't mean it will get it right every time.

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
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 468 Super User 2025 Season 2

#2
stampcoin Profile Picture

stampcoin 52 Super User 2025 Season 2

#3
trice602 Profile Picture

trice602 46 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans