Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Import Data - .csv separator does not work properly.

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.

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    It was a source problem - sorry.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    It was a source problem - sorry.

    • v-yingjl's avatar
      v-yingjl
      Community Support

      Hi Anonymous ,

      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