Data Processing Error

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, powertechbi 

Regarding the issue you raised, my solution is as follows:

1.Firstly, remove unnecessary columns, rows, and formatting to reduce the file size.

2.Secondly, minimise complex formulas and calculations in Google Sheets, and instead, perform data processing and calculations in Power BI.

Get started with Power BI Desktop - Power BI | Microsoft Learn
 

3.Next, install and configure the Power BI gateway to enable scheduled data refreshes from Google Sheets, even when the file is not open.

Configure scheduled refresh - Power BI | Microsoft Learn

 Here is the download link:

Power BI Gateway | Microsoft Power BI
 

4.Finally, here are some links related to your content for further reference:

 Solved: Error 429 "Too many requests" when refreshing a da... - Microsoft Fabric Community

Solved: Google sheet connection with power bi - Microsoft Fabric Community

How to Connect Google Sheets to Power BI

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.