Modify csv data source that is connected to a XLSM file via power query

Hi there.

I have developed a SQL script that exports a csv file.

I have imported this csv file in a .xlsm file and have made pivot tables and other worksheets that are dependent on this table.

It turns out I forgot to trim the spaces in the custname and need them removed. I have modified my SQL query and produced the corrected csv output.

However when I refresh the XLSM sheet, those changes do not appear in the XLSM.

What do I need to do to make this happen?

I have spoke to so many people about this and they cannot figure it out.

See attached files.

these 2 statements totally contradict themselves.

Originally Posted by TheRevenant

It turns out I forgot to trim the spaces in the custname and need them removed. I have modified my SQL query and produced the corrected csv output.

However when I refresh the XLSM sheet, those changes do not appear in the XLSM.

are you saying that your script DOES trim the data such that there are no spaces BEFORE the CSV is imported into excel, and the data DOES appear in excel WITHOUT spaces in it, then when you refresh the worksheet, the spaces reappear? because that makes no sense whatsoever.

Initially the CSV was imported with spaces because the SQL did not use RTRIM.

My SQL script has been edited to perform RTRIM on the field and the exported csv file contains no spaces at the end.

While the data appears without spaces in the CSV file, when I refresh the data in the XLSM file, the spaces remain.

I suspect that new records are showing without spaces and old records are showing with spaces.

I have done TRIM using power query on that specific field and it is okay now.

Originally Posted by TheRevenant

it is okay now.

so have you solved your issue then?