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 (4)
  • Suggested answer
    Romain The Low-Code Bearded Bear Profile Picture
    2,055 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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

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

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 252 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 93 Moderator

Last 30 days Overall leaderboard