Forum Discussion

seanr's avatar
seanr
Regular Visitor
6 years ago
Solved

Missing a Step in using Folder to connect to multiple csv files

I am a newbie and I am trying to read a folder to bring in multiple csv files into powerbi.  I have scowered the community, help files and youtube videos before turning to the forum to resolve an iss...
  • ImkeF's avatar
    6 years ago

    Hi seanr 

    that is a trap of the automatically generated step "Changed Type". That should be the last step in your main table.

    Problem with that is that it contains a hardcoded list of column names before the "Promote header" step. It is still looking for the old column names.

    Easy solution: Delete that last step and do the type transformations again on the new column(name)s.