I don`t get comma separated table

[Frixel]

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?

[Omid_Motamedise]

Oppen the CSV file with Excel and let me know if it shows in Excel in separate columns or just in a single column.

[Frixel]

Hi @Omid_Motamedise 

Yes it opens in separate columns.

[Omid_Motamedise]

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.

[Frixel]

i don`t how to add a attachment here

[Omid_Motamedise]

Follow the process I presented in the next comment, if it does not work, put it into your drive and share the link, or let me know to give you my email if it does not work also

[Omid_Motamedise · Accepted solution]

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])

[Frixel]

@lbendlin 

It must be me but i can't find the function Table.AddColumn with a Csv.Document([Content])  

[Omid_Motamedise]

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.

[Frixel]

@Omid_Motamedise 

There are no delimiter settings in the options in Regional settings

[lbendlin]

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.