Hello,
I am trying to create a calculated field with a parameter in the dataset edit screen, but I got an error that the formula syntax is wrong and the parameter can’t be found when refreshing the dataset.
obs: it works when the dataset is the direct query, but when I change to SPICE I got the error.
Error:
INVALID_DATAPREP_SYNTAX Learn more
A calculated field contains invalid syntax. Correct the syntax and try again.
The last update failed because I added in the calculation field the parameter.
Before the last update, it was successful because I removed the parameter from the calculated field.
It works if I create it during the analysis.
It is not the perfect solution for me because I had to change all the analyses that use this dataset.
I was using the data set with direct query but now I need to change to spice and then I got this error.