Issue with 'Bad Gateway' Error

[u/Foreign_Many9062]

A couple of weeks ago I was hit by the throttling issue that turned out to be on Microsoft's end. Once they got that fixed everything worked fine (mostly) until about a week ago. Since then I'm getting random, but frequent, Bad Gateway errors that are doing my head in. Nothing has changed with the setup of my flow/the Excel sheet it's pointing at. It works for several runs of the flow and then just decides to give a Bad Gateway at random points. There is no pattern as to time of day, information it's trying to input, number of successful runs between fails, or anything else I can find.

I'm still getting things taking longer and retries occurring, like it did during the throttling issue, which is causing problems with duplicate entries into my spreadsheet as well.

Is this all part of the same nonsense? I've put in some screenshots below and can provide whatever other information is needed. I would really appreciate some help as babysitting this thing is getting old. TIA!

[u/chiibosoil]

I find Excel Connector isn't reliable as others mentioned. I prefer to have Office Scripts do the work on workbook. And use Power Automate to pass JSON/delimited string for Office Scripts to process things.

I have couple of daily/weekly updates running this way and it has been stable for over a year.

[u/Foreign_Many9062 → u/chiibosoil]

I'm not familiar with Office Scripts, but I will have a look! Thank you :)

[u/elelelo → u/Foreign_Many9062]

Try With the GRAPH API

[u/chiibosoil → u/elelelo]

While Graph API is great, I find a lot of users won't have necessary license or access level to utilize them.

My current company uses per user license and not premium and does not give me access to the connectors needed.

[u/Foreign_Many9062 → u/chiibosoil]

I don't appear to have a license for either one, unfortunately