Update dataset through excel

Question & Answer
, ,
1

i have two datasets. ive extracted them and merged them in an excel sheet. i now want to re-import the merged excel back into quicksight. i have done this, but whenever i update the excel sheet, it doesnt update in quicksight. How can i make changes to the data in the excel, update the excel, and it updates the data in quicksight?

2

Hi @HarveyB-B ,
by Excel you mean a local Excel file?
BG

3

I think so, as is on my laptop but also synced to my OneDrive.

4

i would say, in that case you need to update the data in QuickSight manualy, by updating the dataset.

5

Does this mean i have to basically create a new dataset every time i update the excel sheet? or can i press a button in quicksight, which looks at the file and updates it and inputs the new data i added/changed?

6

Ah i see, Updating files in a dataset - Amazon QuickSight this allows me to update it

1 Like