with the help of this forum I've almost got this working, but I'm trying to make it both repeatable and durable.

overview:
a client of mine has seven businesses which share employees between them. they are provided with seven disparate payroll reports, exportable in CSV format.

I am get data / from file / from folder and pointing toward a folder with CSVs in it

I have a wonderful transformation:Screen Shot 2022-05-31 at 2.19.16 PM.png

everything looks great on the Power Query editor screen.

but then when I hit CLOSE/LOAD, it dumps all of the raw data into my new sheet with none of the transformations I saw in the Power Query preview. The very first time I did this, it worked great.

What am I missing?