Error 429 "Too many requests" when refreshing a dataflow that has some google sheet files

The solution provided in a microsoft ticket was "Reduce the load/data to avoid too many request error" and to contact Google support. To be honest that reply is not helpful

You may not like it but that reply is accurate. The 429 red card is handed to you by Google, not by Power Automate.

Any idea how to avoid error 429 "Too many requests"

Refactor your workflow to reduce the number of requests against that source system.