Forum Discussion
Paginated Reports - Fetch limit?
Is there a fetch limit for paginated reports? This only happens on one report that we have and it happens to be a report that is supposed to fetch 600k rows. It stops at 365k rows. If I select a smaller date range, it renders the data but as soon as it gets over that 365k, it freezes.
Hi R_Shelley ,
There is no limit on how many lines, only on memory size.
Default memory in each Premium SKU for paginated reports:
- P1/A4: 20% default; 10% minimum
- P2/A5: 20% default; 5% minimum
- P3/A6: 20% default; 2.5% minimum
Maybe you can configure the size of memory.
For more details you can refer this link.
Paginated reports in Power BI: FAQ - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi R_Shelley ,
There is no limit on how many lines, only on memory size.
Default memory in each Premium SKU for paginated reports:
- P1/A4: 20% default; 10% minimum
- P2/A5: 20% default; 5% minimum
- P3/A6: 20% default; 2.5% minimum
Maybe you can configure the size of memory.
For more details you can refer this link.
Paginated reports in Power BI: FAQ - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.