Fabric Notebook - HTTP 430 TooManyRequestsForCapacity when running simple Spark SQL query

Hi Shahid12523 

Thank you for sharing the screenshot.

Based on the error message, [TooManyRequestsForCapacity] typically indicates that the Fabric Spark request is being throttled because there aren't enough compute resources available on the assigned Fabric capacity at the time the notebook is executed.

To help isolate the issue, could you please check the following?

• Are there any other Spark notebooks or jobs running concurrently in the same workspace or on the same Fabric capacity?
• Are there any long-running or stalled Spark sessions that may still be consuming capacity? If so, please terminate them and retry the notebook.
• If you have access to the Fabric Capacity Metrics app, could you verify whether the capacity is under heavy Spark utilization when the issue occurs?
• If possible, try restarting the Fabric capacity to clear any orphaned Spark sessions, wait a few minutes, and then run the notebook again.
• If your organization has Autoscale Billing for Fabric Spark enabled, please verify that it is configured correctly, as this allows Spark workloads to use dedicated serverless compute instead of consuming Fabric capacity compute units.
• If the issue occurs frequently, you may also want to consider using a higher Fabric capacity SKU or, if applicable, a custom Spark pool instead of the shared Starter pool.

Additional reference : Troubleshoot Permission and Capacity Errors in Data Engineering - Microsoft Fabric | Microsoft Learn
Fabric Notebooks troubleshooting guide - Microsoft Fabric | Microsoft Learn

Hope this helps !!

Thank You.