Overcome limitation of 1000 rows for plot

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.