Power Query Fails to Convert Data Type, Error Persists

Ichabod871

New Member
Joined
Jan 11, 2018
Messages
1
Hello,

I have a power query pulling from a CSV file. I have set the data type in one of the columns as text, but there are errors that claim power query could not convert the data in the column to a number. I have tried refreshing the query. I've tried converting to a different data type then converting back to text. I've tried saving and reopening. Nothing works. Please help. Thanks in advance. And let me just take this moment to say I despise Microsoft and their crappy products. There, now I feel just a little better....
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

MarcelBeug

Well-known Member
Joined
Apr 25, 2014
Messages
1,811
Maybe you just have a crappy query of a crappy csv file.
We can't help you if you don't share these (may be dummy data as long as it has the same issue).
 

macfuller

Active Member
Joined
Apr 30, 2014
Messages
270
Office Version
365
Platform
Windows
Without the data it's hard to say. The data in the column may not be all of the type you expect. Sometimes PQ will not know which transformation to apply in order to convert the outliers. Check the column for errors to ensure that the data is all of the type you expect.

For example, PeopleSoft has a known issue where certain characters like copyright and registered symbols in a text field will blow up its export to .csv. The characters are misinterpreted as EOF or EOL and it misaligns several subsequent rows of data. We have to tweak the files so that PQ will recognize those rows as errors.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,285
Messages
5,467,746
Members
406,550
Latest member
miraclewhip

This Week's Hot Topics

Top