AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.4K members online now
4.4K 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...