Excel PowerPivot duplicate column names in source file

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.

Leave a Reply

Your email address will not be published. Required fields are marked *