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

Problem with data from a flat source, that contains a dot "."

Hi guys, I'm trying to import some data from a flat file *.csv I got some errors with the number data type, that contains a dot. Could you please give me a tip, how to set it to a step, that will be done automatically-each time when I will load an updated file.

 

Screenshots:

http://prntscr.com/klmy56

https://prnt.sc/klmvr7

1 ACCEPTED SOLUTION

Thank You, Frank. I found another way to resolve the problem. There was an option in the Excell programme that I need to change. 

I discovered that the new version of Excell 2016 switches the default separator. The solution is to edit the setting and switch it to the one we won't.

 

 

image.png

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @mimasix,

 

Could you please have a try using my way?

 

Firstly, when importing data from csv to Power BI Desktop,  please choose "Edit" in  the following screenshot to load data.

 

1.PNG

 

Secondly, delete the "Change Type" step in "APPLIED STEPS". 


2.PNG

 

Please have a try using this way, if the issue still occur, kindly share your csv file to me.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Thank You, Frank. I found another way to resolve the problem. There was an option in the Excell programme that I need to change. 

I discovered that the new version of Excell 2016 switches the default separator. The solution is to edit the setting and switch it to the one we won't.

 

 

image.png

Hi @mimasix,

 

Awesome, kindly mark your answer as a solution to close the case please.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!