Power Platform SSRS only displays 500 records from a Fetch XML query.

Today I had this problem and I wanted to share the solution with you. I know personally how frustrating it can be to spend hours on an issue that has no reasoning for it.


Basically I created a Fetch XML report. The fetch dataset was only returning 500 records when it should have returned 2000 records. Now fetch datasets have a page size of 5000 and therefore would only return a maximum of 5000 records BUT there was no reason for the dataset to return only 500 records.


The fix is simple, change the root fetch node to have a count of 5000 as per the below example.





23 views0 comments

Recent Posts

See All

There are a number of tricks that can help improve the speed of data migrations. I have bullet pointed them below and included links and references at the bottom of the page. Turn off all workflows (i

Power Platform storage seems to get consumed very quickly. I have had to come up with capacity management strategies for numerous clients over the years. I really do wish Microsoft would increase the