I have a data visualization that is connected to data sources from Google Sheets. However, after I tried to add more Google Sheets data sources, it couldn’t connect. Why does this happen?
The connected data from Google Sheets contained 149,139 rows of data X 7 files. When I tried to connect other sheets, it always failed.
Thank you
Hi @Insan , thanks for your post!
If you are creating the new Google Sheets data source from a report and you are encountering the error there, you can also try adding the Google Sheets data sources as reusable data sources that you can then connect to from the report (rather than configuring a new data source from the report). That way you know that the connection is all set up and ready to add to your report.
If you also encounter an issue when you create the Google Sheets data source as a reusable data source, you might want to look at some of the Google Sheets connector common troubleshooting methods that are recommended by our team.
This Create a Google Sheets data source tutorial also has some good recommendations for making sure that the Google Sheets data is readable by Looker Studio.