Python in Excel - quotas?

[patrick1970]

Hello.  Newbie here, so apologies if this is a naive query.

I'm playing with the new Python in Excel.  While my Python is anything but efficient, I've hit a roadblock with "#BLOCKED - You have exceeded your monthly quota of Python usage."  I can't find anything anywhere to say what this quota is and, more importantly, how to adjust it (happy to pay!).  Thankfully the month-end is only a few days off, but I don't want to build a big Python analysis and then find I can only run it a few times per month.

All thoughts and suggestions welcomed.  Thanks in advance

[#2 · Accepted solution]

@patrick1970 

The monthly quota on Python usage in Excel is currently a limitation that many users are running into. Microsoft has set a monthly usage limit for Python calculations in Excel.

When you exceed this limit, you'll encounter the "#BLOCKED - You have exceeded your monthly quota of Python usage." message. The quota likely includes the number of Python function calls or the total computation time. However, Microsoft has not publicly detailed the exact criteria or limits. This quota typically resets at the beginning of each month. If you've hit the limit, you'll need to wait until the next month or optimize your Python usage to avoid hitting the quota.

There is currently no direct payment option for increasing your quota, as far as I am aware.

My knowledge on this topic is limited, I only describe what I knew up to now, which does not mean that anything has changed in the meantime.

Links:

how to check quota for Azure spot VMs vCPU's using Python Azure SDK?

Getting started - Managing Quota using Azure Python SDK

I would like create quota increase request through cli is it possible.

My answers are voluntary and without guarantee!

Hope this will help you.

[#3]

Very helpful and much appreciated.

[#4]

That's very disappointing. I was looking forward to trying Python in Excel, but I think I'll wait until I learn more about this.