+ Reply to Thread
Results 1 to 3 of 3

Power Query - Stop trying to Convert to number

  1. #1
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Power Query - Stop trying to Convert to number

    So I'm running a query, and it tries to convert certain columns to number, because they are numbers. However I dont want them to be number, I would like them to be general, as it causes errors and will not return the data. Even when I try to convert to text, I still get the error. How do I make the query stop trying to convert the column, and let me just choose what it is?

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,291

    Re: Power Query - Stop trying to Convert to number

    You should be able to remove or edit the relevant Changed type step?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Re: Power Query - Stop trying to Convert to number

    Quote Originally Posted by rorya View Post
    You should be able to remove or edit the relevant Changed type step?
    That is not even a step yet. In the source data step, just the first load, it is already trying to convert them to numbers, so the data doesn't come into the query and only shows error, if that makes sense.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query - Convert Months to Year
    By samparker095 in forum Excel General
    Replies: 3
    Last Post: 07-08-2022, 04:39 AM
  2. [SOLVED] Power Query to convert qty in other UOMs to qty in Report UOM
    By josephteh in forum Excel General
    Replies: 4
    Last Post: 10-27-2020, 09:11 PM
  3. How to convert Text to Date in Power Query
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-11-2020, 01:59 PM
  4. [SOLVED] Convert Formula to Power Query
    By Kcroft9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-11-2020, 10:32 AM
  5. [SOLVED] Power Pivot/Query Convert Existing Table to Query
    By trisoldee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-23-2019, 04:27 PM
  6. How to resolve Data FormatError We couldn't convert it to Number-Power Query
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2019, 01:16 AM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1