Paginated Reports - Fetch limit?

[R_Shelley]

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.

[v-chenwuz-msft · Accepted solution]

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.