Results 1 to 3 of 3

Thread: Expression Error in mixtype column

  1. #1
    Seeker CharlieHall's Avatar
    Join Date
    Aug 2016
    Posts
    6
    Articles
    0
    Excel Version
    2016, 2010

    Expression Error in mixtype column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a dataset being pulled in from a excel workbook that has been exported from some server application.


    The dataset has a field that is primarily numbers as text, plus a few actual text entries plus a few numbers as numbers


    I converted the type in PowerQuery to Any.


    When I export this table to an excel table, the numbers as numbers cause an Expression.Error - can not convert the value 31 to type Text


    This error also comes up inside PowerQuery when I try to filter the column.


    Since the type is 'Any' why am I getting an expression.error - I have not asked for it to be converted to anything but 'Any'


    Converting the column to text does not actual convert the numbers to text, so the error continues to appear


    Suggestions???
    Thanks in advance

  2. #2
    Acolyte pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    33
    Articles
    0
    Excel Version
    Office 365
    A workbook which contais that error could be helpful!

  3. #3
    Seeker CharlieHall's Avatar
    Join Date
    Aug 2016
    Posts
    6
    Articles
    0
    Excel Version
    2016, 2010
    Thanks for following up - I have gone back to the dataset and can not get the error to occur again - and yet it was quite consistent at the time - not sure if anything has changed - if it happens again, I will try to isolate it and post the workbook then

    Thanks

Posting Permissions

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