Forum Discussion
Google sheets
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://-----------------------------------------------------------------------------------------ranges=Sheet1!A1:V356669&fields=sheets/data/rowData/values/effectiveFormat/numberFormat,sheets/data/rowData/values/effectiveValue
this is the error I'm getting.
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.
11 Replies
venkatakrish_01
Are you using the Native Google Sheets Connector? If don't, try this to see the timeout connection is gone.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?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.
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!
No, the is continues
