When importing for example a CSV-file in Excel PowerPivot you can be presented for the error below.
The expression contains invalid date constant ‘#csv.<VARIABLENAME>’.
If that’s the case you might have duplicate column names in the first column of the CSV-file.