Knowledge Drop

Filling is not Allowed in Queries with Limit Exceeding 30000

  • 15 June 2021
  • 0 replies

Last tested: Jul 24, 2019

This is error is in reference to a scheduled job failure. Instead of receiving the schedule, the schedule owner receives an email that the scheduled job has failed with the error message:

Error: Missing values for 'view_name.date_field' were not filled because filling is not allowed in queries with limit exceeding 30000


This is may be due to a pivoted date field with "Fill in Missing Dates" (default) enabled. Even if the displayed data is less than 200 rows and/or column limit is enabled, the schedule will still fail. By selecting "Remove Filled in Dates" from the dimension options, the schedule will send.


This content is subject to limited support.                



0 replies

Be the first to reply!