Hi, i've been trying for hours to figure out what's going wrong, some help would be much appreciated.

I'm combining large data from several sheets saved in a Folder.

In main Query, it detects date type as "date" yet in transformation file detected as "text".  Why would that be? Would this be why i'm experiencing the issue below?

I'm changing it to "date" type in the sample file but still having issues when loading as connection and add to data model.

It fails saying something about couldn't find Transaction date in the table.

Or (when i start again) will load first time ok but then when i do further changes to Query and load, it fails with same type of error.

Thank you

Oli