I’m working on a prototype for Dataset, dashboard and Analysis promotions. To simulate any changes in dataset schemas, I need to ensure nothing breaks if something is updated.
Running into the below, where analyses and dashboards break when updating a dataset. However, the only change to the dataset was adding columns, nothing was taken away.
"Column that used in the field can not be found in Dataset"
That column does exist in the dataset, yet my analyses can’t find it. Why is this? Does the analysis refer to a static index of the column vs. re-fetching after a dataset update?
Hi @evanbetterc Could you please confirm that all the columns that previously existed have the same column name and data type?
When you edit a dataset, try not to make changes that might break existing visuals. For example, don’t remove columns that are being used in a visual. If you must remove a column, create a calculated column in its place. The replacement column should have the same name and data type as the original.
Hi @evanbetterc - Please ensure the column which is deleted are NOT part of the any analysis and also @SD_QS correct, please ensure there is NO change in the column names or else it will throw an error.
The column names are the same, what I observed was when creating the dataset manually and updating via the API, some config or mapping broke… I couldn’t figure it out, but when I went all API it updated properly. Thanks!