Pivot Table Error (GA4 connector - any row dimension by date column)

[spindogs]

All pivot tables that are connected to GA4 (possibly other connectors have the same issue)
are generating a SYSTEM ERROR.
The pivots can be for any dimension, but they all use a date field across the columns (either by day or year + month groupings).

If we remove the column dimension, then the pivot displays - but obviously with the appliable data missing.

I have deleted and recreated the pivot tables - with no luck.

The date range is generally set to 12 months.
If I drastically REDUCE the date range (2 months) then the Pivots mostly work again - so it seems to be related to how much data is being pulled for the pivot.

[spindogs]

Also now tested with a Google Ads connector - same issue.

[stellasimon]

We have the same issue since this morning (UK), it's working intermittently but failing most of the time 

[spindogs]

Yep - it seemed to have started very late last night.

I have had some luck with reducing the date ranges down from 12 months to between 2 and 6 (its very inconsistent).

[spindogs · Accepted solution]

Issue Fixed - all pivots now showing full data set, no errors.

No idea what that was about - perhaps a Looker update in comming down the pipe.