Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Google Sheets number of rows limit?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone, 

 

I've been happily using Data Studio with a few different Google Sheets. But I realized that at least one tab only "exported" 1500 rows to Data Studio. Is that a bug? A hard limit? A parameter? 

 

Any way to change it?

 

Thanks, 

Patrick

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Patrick P
May 2017

Google Sheets number of rows limit?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

False alert... I had a problem with my input data: the date field had reverted to "number" format (instead of date) after row 1500, which apparently, Data Studio can't handle as a date. Weird that the cell format in Google Sheets should have an impact in Data Studio, though...

View solution in original post

Google Sheets number of rows limit?

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I hadn't heard this, I'm interested in the answer.

Marked as Best Answer.
Solution
Accepted by topic author Patrick P
May 2017

Google Sheets number of rows limit?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

False alert... I had a problem with my input data: the date field had reverted to "number" format (instead of date) after row 1500, which apparently, Data Studio can't handle as a date. Weird that the cell format in Google Sheets should have an impact in Data Studio, though...