Forum Discussion
Paginated Report Error while loading dataset
Hi Narasapuram-Swa,
Those first two errors seem to be the result of the last error.
Your XML data is being cut off as it times out, and therefore is no longer valid XML causing validation issues in the first two errors.
Microsoft’s guidance for paginated reports over semantic models is to reduce data volume as much as possible and push aggregations into the model, not the report. See Performance and scalability considerations for paginated reports.
One thing you can try:
Check and increase dataset timeout
- In Report Builder, go to Dataset Properties > Options and set an explicit timeout value (for example 600 seconds or higher) instead of leaving it at the default.
- For paginated reports, timeouts are controlled at the dataset level, and there are also environment-level limits. See Set time-out values for paginated report dataset processing.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi Narasapuram-Swa ,
I would also take a moment to thank tayloramy , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
Hi Narasapuram-Swa ,
hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you