Google sheets

Hello again venkatakrish_01 ,

Thanks for confirming the details. Since you’re connecting through the Google Sheets connector, the timeout error is likely happening because the connector relies on Google’s API, which isn’t optimized for loading very large datasets. With over 350,000 rows, Power BI is trying to pull a large amount of data at once, and the request is timing out before the API can return all the records.

A simple way to work around this is to reduce the data size in your sheet by splitting it into smaller parts or publishing it as a CSV file instead. You can then use the CSV link to connect through the Web option in Power BI, which generally handles larger data more efficiently. Another option is to move the data into a source like BigQuery or a database, which Power BI can connect to without hitting these timeout limits.

This issue isn’t specific to your setup but rather a known limitation with how the connector interacts with large Google Sheets. If you try the CSV link method, it should resolve the timeout and let you load your data successfully. Let me know if you’d like me to share the steps for setting that up.

Thank you,

Tejaswi.