Overcome limitation of 1000 rows for plot

Hi tan_thiamhuat,

We sincerely appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding, Fabric Notebooks apply a default visualization limit of 1,000 rows in the display() function or SQL-based chart output. This limit is designed to optimise performance and rendering within the user interface.

Please follow the steps outlined below, which may help in resolving the issue:

1. Use display() with an increased row count to visualise more than 1,000 rows by explicitly specifying the row_limit parameter:
   %sql
   display(
   spark.sql('SELECT Date, ROUND(SUM(rainfall),1) AS daily FROM FabricRainFloat WHERE location = "Clements Road" GROUP BY Date ORDER BY Date'),
   row_limit=5000
   )
   This parameter allows chart rendering up to the notebook UI table limit of 10,000 rows or 5 MB.

2. If the dataset exceeds 10,000 rows or 5 MB in size, please apply SQL filters to restrict the data to selected periods such as monthly or quarterly intervals. Render charts incrementally to display data in chunks by year or month.
   %sql
   display(
   spark.sql('SELECT * FROM ... WHERE Date BETWEEN "2025-01-01" AND "2025-12-31"'),
   row_limit=10000
   )
   This approach prevents UI truncation and ensures each visualisation is within the supported thresholds.

For your reference, please go through the following links:
Notebook visualization - Microsoft Fabric | Microsoft Learn
Fabric Notebook known limitation - Microsoft Fabric | Microsoft Learn

We hope that the information provided will assist in resolving the issue. Should you have any further queries, please do not hesitate to reach out to the Microsoft Fabric community.

Thank you.