I am trying to update a visual with a new excel sheet into dataset every day. It usually works but the last two days I am getting this error and I have not changed anything. I don’t know why it’s not pulling the data in any more. Help?
| sourceErrorCode: | CONTEXTUAL_INVALID_ARGUMENT_TYPE |
|---|---|
| sourceType: | SPICE |
Hello @snroth , welcome to the Quick Sight community!
I would first double check that all of the field names and data types are consistent across data uploads. Changing data in visuals can be tricky because if anything changes (primarily data types) it can break the visuals.
How would I check that? The file is taking and uploading successfully and I haven’t changed any names or titles from the last week.
Hey @snroth
If you go to the data prep layer, you can check the data types for the fields.
They are all strings. There’s only 4 columns in the sheet I’m uploading and they match the fields title. They just show as null values in the visual and dataset.
Hey @snroth
So on ingestion in the dataset is coming back as nulls in the preview? Also, to take this a step back, how are you uploading the new data? Are you updating the file in Quick Sight or are you adding a new dataset and swapping it in the analysis?
I am pulling data from SIM into an excel sheet then uploading that excel sheet into a dataset. The dataset is a join type left, lm1 is on the left, DATA1 is on the right so the sheet I uploaded is getting matched to lm1 (Launch manager data). The file uploads and then in preview it shows all as null. I can still publish fine without error messages but then when I go to the visual the whole board is shows as a syntax error.
I worked with another employee today to resolve the issue. Two things: It was an incorrect API Change and Change Console field calculation that was pulling the wrong true, false and null responses (so nothing with my datasheet)
