Issue refresh dataset with calculate field using parameters

Question & Answer
, , ,
1

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.

Error details: Didn't find parameter parameterTest

Dataset:

image
image695×284 13.5 KB

parameter:
image

calculated field
image

2

@miguelhentoux Can you click on the parameters section of this dataset?

1 Like
3

@Max yes, I can click on it:
image

inside of calculated field:

image
image779×1059 16.4 KB

4

Did you make sure you published the dataset?

5

Yes, sure.

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.

image
image1901×755 61 KB

6

Are you creating the parameter on the dataset itself or in the analysis?

7

I am creating during the dataset creation.

8

Try creating the parameter once the refresh is done. And inside the analysis.

9

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.