When I refresh my dataset, I receive the following error-
INVALID_DATAPREP_SYNTAX A calculated field contains invalid syntax. Correct the syntax and try again.
Error details-Found duplicate aliases [Column-12]
I upload xlsx files successfully and refresh errors out. When it states Column 12, Is that column 12 on xlsx or from dataset? I do not see duplicate column name. Does duplicate aliases referring to the column name?
Hello Maria,
It seems that this dataset includes a join operation, and after the join, there could be duplicate column names present.
In situations like this, the duplicate column names typically originate from duplicate columns in the datasets or data sources. It is likely that the same column exists in another dataset or data source, hence the error.
My recommendation would be to open a support ticket through the AWS console and reach out to the Quick Sight team. They can assist in confirming whether the issue stems from the dataset or the data source.
Regards,
1 Like