Context: It appears that Quicksight is not able to refresh new columns from a joined dataset and the only way to get them to appear is to remove the join and recreate it. However, this causes the “changed to quickly error”.
I have completely removed the dataset from the analysis, published the analysis to a dashboard without the dataset.
Then I re-added the dataset and it still gives me that error. If I create a new analysis from the dataset itself it works fine so somewhere under the hood there is some hidden reference/connection that Quicksight is not removing even when a dataset is fully removed from an analysis.
Any ideas on how to resolve?