Solved: Dashboard Render Error - Page 2

ginandtobby

Hi Community!

I have a Looker dashboard that runs ok - everything loads and displays nicely in the dashboard itself, but when I schedule delivery, I receive this error message:
Error: Error occurred while generating this dashboard - contact administrator (error: Render job XXX failed [query failed: Missing values for 'XXX.partition_date_month_name' were not filled. Only one dimension is allowed when filling in missing rows.])

More context on this: I'm using month_name from time dimension group to plot a chart, but I want to keep the first 3 letters instead of the month full name. I used a custom dimension to extract the month name, but I need to sort it in month orders, so I used both columns, one for x-axis value display, one for sorting:

It seems like the render error has something do to with this, but I don't know why it works fine in dashboard while showing errors in scheduled delivery. Please advise what is the quick fix for this.

Thanks!

ruthc

The error message suggests it's something to do with filled in dates (this is a feature whereby Looker will automatically fill in missing dates, even if there is no data for that date).

1. EITHER click on the gear icon for 'Month Name' > 'Remove filled in dates', and see if this fixes the problem; OR

2. Remove both month columns, and replace with the 'month' option from your date dimension group > click on the 'Edit' button for the visualization > 'x' tab > Time Label Format = %b (this will transform values like 2025-06 to Jun)

View solution in original post