I’m trying to create an SPC-style time series graph. X-axis is a datetime (seconds fidelity). Data source is BigQuery. Because scatter plots in Looker Studio are largely pointless, I’m using a line chart with zero-width lines, and showing data points.
When I set the dimension data type to ‘Date & Time’, to get the full fidelity, I get a “Too Many Rows” error (see screenshot). It works ok with ‘Date Hour’, but nothing lower.
There are ~1,800 rows and 11 columns in the full dataset, and it’s being filtered in Looker Studio via a drop-down list to actually display less than half of these. I can get it to render with ‘Date & Time’ when there are ~100 data points, but that’s the most it’ll display, which is way fewer than I’d expect.
Am I doing something stupid, or can it really only handle ~100 data points?
Not sure how old this thread is but the issue is just the way the date is presented in the source field, particularly where the time value is appended.
I had the exact same behaviour with a table of only 400 rows.
My date column was carrying the format:
2025-09-08T06:46:40.131Z
2025-03-19T06:43:49.923Z
2025-03-19T06:38:12.607Z
I solved the issue by creating a calculated field that stripped away the timing information called “Clean Date” like so:
PARSE_DATE(‘%Y-%m-%d’, SUBSTR(publishedAtDate, 1, 10))
This produced standard YYYY-MM-DD values.
I used this calculated dimension for all date references instead of the source dimension, and this worked.
Hope this helps.
Sure, it’s straightforward to make the issue go away - but then Looker Studio will aggregate all the data points for each day, into a single data point. And I want to display all the data points individually.
