The issue here was that I was using one connection for all the excel connectors in the one app. The solution was to create multiple connections and distribute them through the app.
Error code: '429', Message: Rate limit is exceeded when trying to edit an excel connector
I'm finding it increasingly difficult to update some of my logic apps. When opening the connector to change anything I constantly get this rate limit exceeded message. So far this seems to be most common with excel connectors but I've seen it with others. I've check throttling and there does not seem to be any so was wondering if anybody out there might have some suggestions as to what the issue might be?
Error code: '429', Message: 'Rate limit is exceeded. Try again in 58 seconds.'. More diagnostic information: x-ms-client-request-id is 'BC4BBF05-F586-496D-A25C-5D6FAEEA95FE'.
Azure Logic Apps
1 additional answer
Sort by: Most helpful
-
MayankBargali-MSFT 70,936 Reputation points Moderator
2021-08-18T03:36:19.417+00:00 @Gareth Terblanche As per the below error message you have shared this is more towards the ARM throtlling limit where you may recive 429 error code and retrying the operation after some time will help you to mitigate the issue.
Error code: '429', Message: 'Rate limit is exceeded. Try again in 58 seconds.'. More diagnostic information: x-ms-client-request-id is 'BC4BBF05-F586-496D-A25C-5D6FAEEA95FE'.
As per the x-ms-client-request-id that you have shared I can see the POST i.e. write operation per hour 1200 writes on the subscription/tenant level.
Regarding your other issue that you have observed that the connection becomes invalid. Can you please confirm if there the credetendial are not refreshed/changed that is used for excel online that might be causing this behaviour.