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

Community site session details

Session Id :
Copilot Studio - Model Context Protocol
Suggested Answer

Dataverse MCP Server Read Query 20 row limit

(1) ShareShare
ReportReport
Posted on by 59
Dataverse MCP Server read_query tool currently only returns max or 20 rows even when the query requests more.  This is a ridiculous limit for almost any use case!
Is there a way to increase this limit?
If not, is it on the roadmap? 
I have many use cases for using this MCP Server so it would a great benefit to be able to control this for use cases that require it.
I have the same question (3)
  • Suggested answer
    Romain The Low-Code Bearded Bear Profile Picture
    2,037 Super User 2025 Season 2 on at
    Dataverse MCP Server Read Query 20 row limit
    the limit is a problem i agree, ATM without using external tool, you coul try with the prompt tool it has dataverse capacity and in the settings in the prompt windows you could change to thousand of element for the query. it's a workaround but it could work (but add a lot of complexity, you have to route all question wich need datataverse to you'r prompt tool)

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

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 304 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 224 Super User 2025 Season 2

#3
Sam_Fawzi Profile Picture

Sam_Fawzi 78 Super User 2025 Season 2

Last 30 days Overall leaderboard