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 issue that is probably simple but for some reason I cant see to find documenation on.

 

In converting from file folder, I understand all of the steps needed except for reloading the intial combined table after the sample file has been used to create all of the transformation steps.

 

Here is where I am stuck:

 

-I connect to my folder

-I see the list of my files and choose "transform data"

-I click on the "Content" column to combine all of the files an

-I accept the default for using the First File for sample.

-Query Editor opens with the helper queris and an outputed result for the combined files

-I click on the Transform Sample File and make a series of changes that I can see in my applied steps.

-However, the default output does not change when I promote headers and this is where I am stuck.  It reflects all the changes until I get to the step where I am promoting a row to be used as headers, the default output no longer is referencing the column names as [Column 1, 2, 3, etc] and its givng me the triangle with an exlamation mark (and on apply and close I get the error message "The column 'Column1' of the table wasn't found".

 

I am sure its a simple reload of the final output with my applied steps, but I cant seem to find how to make this work (invoke function?  what do i put in the parameter box?).

 

I know its going to be a duh! moment, but I do appreciate if someone can point me in the right direction.

 

Thanks.

 

 

 

 

 

 

  • 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.

     

2 Replies

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion

    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.

     

    • seanr's avatar
      seanr
      Regular Visitor

      Thank you so much for your help!