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,
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.