Import Data - .csv separator does not work properly.

[mraass]

Hello to the community,

first of all: i tried to find a solution for this particual problem here, but with no result.

I´ve never had any problems like this and maybe the data souce does not work correctly, but i want to exclude the possibility first, that there is something wrong in what i am doing here.

The .csv files i use are only separated in the first row by delimiters, all others are excluded.

But: i am able to split them in the power query editor, however the first row is the following problem.

Are there any ideas what i could do, to solve this problem?

By the way: the pic shows what i mean.

[mraass · Accepted solution]

It was a source problem - sorry.

[v-yingjl]

Hi @mraass ,

So it was a data source problem and has it already been solved by yourself? If so, you can accept your reply as solution, that way, other community members could easily find the answer when they get same issues. 

Best Regards,
Community Support Team _ Yingjie Li