cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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.EML Files CSV1.jpg

 

1 ACCEPTED SOLUTION
Frequent Visitor

It was a source problem - sorry.

View solution in original post

2 REPLIES 2
Frequent Visitor

It was a source problem - sorry.

View solution in original post

Community Support
Community Support

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors