csvpowerbipowerquery

Split column after getting multiple different CSV's into PowerBI/PowerQuery

Thank you in advance for you time and effort. I'm struggling with the following.

I want to load multiple different CSV files into PowerBI using Powerquery.These are separate files and `i do not want to combine them into 1 table. I've managed to set up the connection but stuck as the stage right below. I have filtered down to the 4 files that I want to load and applied the Csv.Document function. However now all data is in 1 column and I would like to split them using the semicolon (';') but can't get it to work.

enter image description here

I have tried enriching the Csv.Document function but can't see how to solve the error:

enter image description here

Solution

  • maybe you can try this

    = Table.AddColumn(Source, "Custom", each Table.SplitColumn( Table.PromoteHeaders(Csv.Document([Content])),"col",Splitter.SplitTextByDelimiter(",")))

    enter image description here

    Table.SplitColumn