Forum Discussion
I don`t get comma separated table
Hello,
When i have a comma separated .csv file, Power Bi will not create a table with the multiple`s colomns after 'Combine files'
Whats goes wrong?
After loading your data into Power query like the next image
go to addd column tab and select custom column
then in the oppend window write the next formula
Csv.Document([Content])like the next formula
it result in a new column inclsuing table with different columns
like this
if it does not solve by the previous one, use this formula
= Csv.Document([Content],[Delimiter=",", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None])
10 Replies
Check the regional settings in Power BI under File > Options and settings > Options > Regional settings, and make sure that the settings match the delimiter used in your .csv files.
Oppen the CSV file with Excel and let me know if it shows in Excel in separate columns or just in a single column.
Ok, no worries, I will provide you solution in a minute here,
if you could share your data with one row of info which your data will replaced by other data, I can provide exactly the code for you, then you can copy and paste it.
Don't use "Combine Files" - that is a function for beginners, and comes with a lot of extra baggage that you don't want. Instead use Table.AddColumn with a Csv.Document([Content]) formula. You can specify the column separator in the parameters of the Csv.Document function.
