Add an extra field from a data source

I have this issue also and it is very frustrating. We add addional columns and fields to source csvs all the time.

I have a work around that used to work...until today.

This way you will not lose any of your steps, which is very important especially if you have a complicated report that could break.

The work around is this:

1) refresh everything, make sure the new column is in the source csv

2) under applied steps in query editor, go to source and hit the settings gear icon to right of "source"

3) Choose Open file as "Automatic" hit OK

4) Your table will dissappear, double click the csv file icon, hit "insert" when the insert step box pops up

5) Your newly added column will appear at step 1 "source"

6) to make sure it stays , under "choose columns" or if you have a "removed columns" ...make sure the check box for that new column is checked

7) Your column is good to go now

This usually works. Except today it started giving me a wierd error after applying query edits Which is why I am here searching.

EDIT* I fixed my error. I was being dumb. My work around works again.