Google sheets

[venkatakrish_01]

Hi 

Currently, I'm trying to connect my Google Sheet with Power BI Desktop, and I'm getting a timeout error. And my Google sheet has records of 356669, while connecting this Google sheet, it's giving me an error.

DataSource.Error: The operation has timed out Details:

https://-----------------------------------------------------------------------------------------ran...

this is the error I'm getting.

[venkatakrish_01]

Hi Marcel Magalhães,
Yes, I'm currently using the native Google Sheet connector, which is provided by default in Power BI Desktop. Should I use any other alternative connection?

[v-tejrama]

Hi  @venkatakrish_01 ,

Thank you @marcelsmaglhaes   for the response provided! 

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[venkatakrish_01]

Issue still continues

[v-tejrama]

Hello again @venkatakrish_01 ,

Thanks for getting back to us! Could you please let us know how you’re connecting your Google Sheet to Power BI Desktop is it via Get Data > Web or the Google Sheets connector? If you could also share the exact error message you’re receiving, it would really help us pinpoint the cause of the timeout.

Best Regards,

Tejaswi.

Community Support

[venkatakrish_01]

No, the is continues 

[v-tejrama]

Hi @venkatakrish_01 ,

Thank you for the update, Could you please let us know how you’re connecting your Google Sheet to Power BI Desktop is it through Get Data > Web or the Google Sheets connector?

Also, if you can share the exact error message it’ll help us understand what’s causing the timeout.

Best Regards,

Tejaswi.

Community Support

[venkatakrish_01]

Yes, I'm connecting through Get Data > Google sheets connector. Error I got it 

DataSource.Error: The operation has timed out Details:

https://-----------------------------------------------------------------------------------------ran...
The https I have marks in ------ because that is the address for my Google sheet rest is the same. 

[v-tejrama]

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.

[marcelsmaglhaes]

@venkatakrish_01 In fact, it is recommended to use the Google Connector. And, in fact too, the connection with Google is weird. I had some dataflows which connected to Google and every day the data refresh failed. So, I created xlsx files from Google Sheets and put them in the Google Drive mapped to a hard disk. That solved my problem.

[marcelsmaglhaes]

@venkatakrish_01 

Are you using the Native Google Sheets Connector? If don't,  try this to see the timeout connection is gone.