In Power BI, I can easily replace column from one table1 from table2 by simply drag and drop column from table2 into the field of the visual.
But I can not seem to do that in Quick Sight, when I click on a visual, it would show the dataset in the top left drag down menu, when I go to do drag down and choose my desired new dataset, this would deselect my visual and I cannot drag the column of the new dataset to any visual on the Analysis. Click on the column of this new dataset will create a new visual.
This is very confusing and does not make sense. Why is the visual tied to a dataset permanently after it is created?
Hi @Benjamin_Blackswan,
You’re right that QuickSight visuals are tied to their dataset at creation time, and it’s not as fluid as Power BI’s drag-and-drop. To swap the dataset for an existing visual, you need to use the “Replace dataset” feature at the analysis level. Go to the dataset panel (top left), click the dropdown menu next to your current dataset, you should then click the 3 dots, you should see and select “Replace.” This lets you map the old dataset to a new one, as long as the field names and types are compatible, your visuals will update to use the new source without needing to recreate them. It is important to note that if the field names are different, then QuickSight will ask you to manually map the columns. Here is the official AWS documentation for replacing data ( Replacing datasets - Amazon Quick ).
For cases where you just want a single visual to pull a column from a different dataset (like you’d do in Power BI), QuickSight doesn’t support cross-dataset visuals natively. I think the workaround to this would be to join or union your different datasets together at the dataset preparation level so all the fields you need are available in one dataset.
Hope this helps and feel free to reply with any additional questions regarding this topic!
@WLS-Cesar
Thank you for the reply. I was able to implement your first suggestion and it indeed changed the visual in question but it also broke all other visuals in my Analysis.
Regards.
Ben.