I update a report daily - one main query uses the combine files from folder and transform step.
The 'transform' step has broken with the latest update of Poawer BI delivered automatically overnight.
None of my backup files work. I believe this is a bug
That seems to work fine for me. You may check code in the advanced editor.