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

Last line "Null" in table from Google Sheets

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, 

As you can see on the below picture, in Google Sheets I have a table with 3 rows, and when I put this in Google Data Studio, there is a fourth row "null"... Can you help me to solve that problem?

Thanks a lot!

problem.last.row.null.jpg

 

Last line "Null" in table from Google Sheets

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I have found the reason of this last line "null" : it appears when other columns of the same tab have more lines than other columns... for example, in the above picture, columns "D" and "E" have 3 lines. If columns "B" and "C" have 10 lines, then the last line "null" will appear in Google Data Studio.

My solution -> using multiple tabs in Google Sheets.

 

Last line "Null" in table from Google Sheets

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi, 

yeah, very annoying bug. Couldn't send my client's report tonight because of it.


Workaround works, but as I have already a tab by customer, it becomes very messy .. 

Empty String gives the same bug.

other workaround : fill up with blank spaces (" ") .. but you have these ugly empty lines..

Any idea ?