What causes INVALID_PARAMETER_VALUE?

`DATE_TRUNC` called with an invalid unit string such as 'FORTNIGHT'. `DATEADD` or `TIMESTAMPADD` with a unit not recognised by the runtime. Window frame boundary specified as a negative number of rows. Partition column value outside the valid range for the column's type. Configuration property set to a value outside its accepted range via SET

How do I fix INVALID_PARAMETER_VALUE?

Check the Databricks documentation for the specific function to confirm valid parameter values. Use `DESCRIBE FUNCTION EXTENDED ` to see accepted parameter values and examples. Validate dynamic parameter values in application code before passing them to SQL. For date functions, use standard SQL interval units: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND. If the parameter is user-supplied input, add input validation and allowlist checking

Medium severityquery

Power BI Refresh Error:
INVALID_PARAMETER_VALUE

What does this error mean?

A parameter passed to a SQL function or DDL/DML statement contains a value that is syntactically valid but semantically out of range or logically inconsistent.

Common causes

1`DATE_TRUNC` called with an invalid unit string such as 'FORTNIGHT'
2`DATEADD` or `TIMESTAMPADD` with a unit not recognised by the runtime
3Window frame boundary specified as a negative number of rows
4Partition column value outside the valid range for the column's type
5Configuration property set to a value outside its accepted range via SET

How to fix it

1Check the Databricks documentation for the specific function to confirm valid parameter values
2Use `DESCRIBE FUNCTION EXTENDED <function>` to see accepted parameter values and examples
3Validate dynamic parameter values in application code before passing them to SQL
4For date functions, use standard SQL interval units: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND
5If the parameter is user-supplied input, add input validation and allowlist checking

Frequently asked questions

What are valid unit strings for DATE_TRUNC in Databricks?

YEAR, YYYY, YY, QUARTER, MON, MONTH, MM, WEEK, DAY, DD, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND — all case-insensitive.