Column headers not matching values

Hello,

I have a data source loaded in QS and works as expected, but next day or after a couple of days the dashboards shows inconsistencies and when I check the database I see that the column headers do not match the values… I could not find any solution, just to create a new dataset and replace it.

Thanks!

Did anything change in the source location?

The source is csv stored in an S3. This csv is the output of a python script that runs everyday, and loads the csv to the S3. The csv column headers and values always looks good on the csv.
Some of the values of the dataset can change because the file is being updated everyday.
Did I answer your question?

So it’s happpening when the pyton code runs?

The python script uses an API to extract data from one site ,does some preprocessing with the data and finally upload the file to S3 using boto3.

Hi, @Dharmesh_Chauhan. Did @Patricia’s solution work for you? I am marking their reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!