Excel file

Q&A
, , , ,
1

Hello,
My dataset is based on different tables from an Excel file.
I’m facing two problems:

  1. When I add/change a record and load the data, the dataset does not change.
  2. Quicksight flips the dates I have in Excel - it reads the month as a day and the day as a month.

How can I solve it?

Thanks in advance,
Mia

2

Hi,

For the point one, try to load new file on an other dataset. Or check you are loading the different file or older one. QS has no issue for uploading the data again and again.

Check your analysis, may be data uploaded but not shown in visual due to some filter etc ?

Second query, You need to create new date column for date formate in excel and make sure you are using the same format throughout the file.

Regards,
Naveed Ali

3

Hi Naveed,

The tables themselves don’t change in QS when I refresh although the data has changed in the Excel file.

4

Hi,

you can try it with another new dataset using the new file.

regards,
Naveed Ali