Results 1 to 3 of 3

Thread: Power Query Fails to Convert Data Type, Error Persists
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query Fails to Convert Data Type, Error Persists

    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....

  2. #2
    Board Regular MarcelBeug's Avatar
    Join Date
    Apr 2014
    Posts
    1,811
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Fails to Convert Data Type, Error Persists

    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).
    Specializing in Power Query (M).
    Using Excel 2007 (Dutch) and Excel 2016 (Office 365 ProPlus) (Dutch/English), both on Windows 10.
    Array formulas can be recognised by the {} Excel puts around it automatically when you press Ctrl+Shift+Enter upon formula entry.

  3. #3
    Board Regular
    Join Date
    Apr 2014
    Location
    Mitten State
    Posts
    235
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Fails to Convert Data Type, Error Persists

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •