Announcements
No record found.
How many records can a fetchxml on SSRS retrieve on a single go?
Hi Rohit,
The limit isn't on the number of records but rather on the time it takes to execute the report.So if the report and query are very simple, you can retrieve much more records than a report with complex aggregates, formulas and queries.
In Power Apps / Dynamics 365, SSRS reports and queries can execute for up to five minutes.
This documented here: https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/reporting-considerations
Henry
Hi Henry,
Thanks for the quick response.
Can you tell me when this 5000 limit had been lifted?
In SSRS, this has been the case for as long as I can remember, as it's supports paging.
Does the fetch go through RetrieveMultiple Plugins or get data from SQL directly?
I don't think it gets the data from SQL directly but rather from the APIs.
As for honoring RetrieveMultiple messages for plugins, I don't know, I would advise to test that scenario.I know that in the past versions it wasn't.
Our SSRS reports are really fast. So, I don't think they are going through RetrieveMultiple now.
Anyways I will do a test.
I really appreciate your help. Thanks
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 172
ManoVerse 58 Super User 2026 Season 1
Niki Patel 42
