Overcome limitation of 1000 rows for plot

[tan_thiamhuat]

I need to show the plots of all data, however, it was limited to 1000 rows. How do I overcome this? thanks

[v-pnaroju-msft]

Hi tan_thiamhuat,

We are following up to inquire whether you have raised the support ticket. If you have already done so, we kindly request you to share your feedback regarding the issue raised.In case a solution has been provided, we would be grateful if you could share it with the community. This will assist others facing similar challenges and benefit the wider community.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi tan_thiamhuat,

We wish to follow up and inquire whether the workaround details we provided have resolved your issue.
If the proposed solution has not addressed the problem and continues to affect your workflow despite the workaround, we kindly request you to raise a support ticket with Microsoft using the following link:
Microsoft Fabric Support and Status | Microsoft Fabric.

Should you require any further assistance, please feel free to connect with the Microsoft Fabric community.

Thank you

[BhaveshPatel]

For that, You should use Power BI Service rather than using Spark SQL in Delta Lake. Power BI Service has great interface of data visualizations and interactivity as well. For example you can create great visualizations using line chart or bar chart etc etc. Data is a limited in online public cloud account. ( ~ 10,000 rows in Delta Lake and 1000000 in Power BI Service)

[v-pnaroju-msft]

Hi tan_thiamhuat,

Thank you for your update and for sharing the details of the error encountered.

Based on my understanding, the error message "WebGLRenderingContext: parameter 1 is not of type 'WebGLProgram'" is related to a WebGL rendering issue within the browser while interacting with the chart. This issue typically arises due to graphics driver limitations, disabled GPU acceleration, or a failure of the WebGL context in the browser, and is not related to SQL logic or Microsoft Fabric itself.

Kindly follow the steps below, which may help to resolve the issue:

1. Please use a supported browser such as the latest version of Google Chrome or Microsoft Edge. Also, ensure that hardware acceleration is enabled in the browser settings.
2. Alternatively, you may bypass WebGL altogether by using Python plotting with Matplotlib. This approach avoids interactive rendering issues by plotting the chart directly. Please find the sample code below for your reference:
   
   

   df = spark.sql("SELECT Date, ROUND(SUM(rainfall),1) AS daily FROM FabricRainFloat WHERE location = 'Clements Road' GROUP BY Date ORDER BY Date").toPandas()
   import matplotlib.pyplot as plt
   plt.plot(df['Date'], df['daily'])
   plt.xlabel('Date')
   plt.ylabel('Daily Rainfall')
   plt.title('Rainfall Trend - Clements Road')
   plt.show()

We hope that the above information will assist in resolving the issue. Should you have any further queries, please feel free to reach out to the Microsoft Fabric community.

Thank you.

[tan_thiamhuat]

can Microsoft fix this instead of relying on the matplotlib library? Databricks can do all the plotting seamlessly.

[v-pnaroju-msft]

Hi tan_thiamhuat,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[chetanhiwale]

Hi @TAN ,
 @v-pnaroju-msft  seems to have shared a valid and appropriate answer. Hope it solves your query as well. 

[v-pnaroju-msft]

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.

[tan_thiamhuat]

when I click the chart, it says: