The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code '429'.

[PowerGirl]

Hello everyone,

I have a flow that updates information from SharePoint to different tables in an Excel file. It is working correctly. However, I had do change the name of two columns in the excel file. When I want to go back to the flow to update it with the new column names I can not do it. Since last week I get the error: 

The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code '429'. This may indicate invalid input parameters. Error response: { "statusCode": 429, "message": "Rate limit is exceeded. Try again in 48 seconds." }

I tried again later, rebooted my computer, rebooted the internet, logged off and on again, and to be honest I have no clue what else to do to get access to the different columns in my excel tables and update the link to the new column.  Any suggestions?

[dannyfarrington]

I'm getting this issue daily and it's becoming really frustrating. 

If anyone has the resolution, it would really be appreciated.

[PowerGirl]

What I finally did was remove the connection, create a new connection and assign it to all the connectors again. That worked for most of the steps but one. For that one I erased it and created it again. Now it is working, but let’s see for how long. 

I read it is better to split your flow in multiple smaller ones and call them with an api. But for that you need premium connectors. 

Here is a good article about it

https://sharepains.com/2018/07/16/error-429-rate-limit-is-exceeded/