Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

error messages when applying changes

Hi all,
 
I just created a query from a folder to combine several several files into one. In the query editor all seems to go fine and everything works. Now, when I tried to apply changes the following error message pops up for the new table (and the 2 other tables that are duplicated from this table).
 
Hotel Budget
Failed to save modifications to the server. Error returned: 'The value for 'Semester Allocation old' cannot be determined. Either 'Semester Allocation old' doesn't exist, or there is no current row for a column named 'Semester Allocation old'. OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a Date value.. '.
 
 
Any help on what this all means and how I can solve it?
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    When you want to combine number and text, you could try below M code

    = Table.AddColumn(#"Changed Type", "Custom", each [text column]&Number.ToText([number]))

     In addition, you also need to check whether there is any other error in your power query  

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • tex628's avatar
    tex628
    6 years ago

    From that error message it appears that you are at some point creating a custom column. In this custom column you are trying to add the values of two columns together where one contains values that are not numeric.

    From what i can tell it is the right column in the expression that is the problem as it contains "DIRSHRO30" which is a text value. 

    I don't really know what the appropriate action here is, as i don't know the purpose of the custom column. You could filter away the text values beforehand if the rows are not relevant.

    Br,
    J

6 Replies

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    This sounds like there is an incorrect value present in column you are converting do dateformat. Try finding the column and then use the keep rows -> errors to identify the row that is the problem. It's most likely only one row or a few which is why there doesnt appear to be any issue before you load the query. 

    Br,
    J

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the help Tex. I have been working hard to extract all errors from my queries. However, with one of them the Keep Rows trick does not work. I get the following message when I try to collect the errors with your way of working:

       

      Expression.Error: We cannot apply operator + to types Number and Text.
      Details:
      Operator=+
      Left=0
      Right=DIRSHRO30

       

      This time inside the query editor. It seems as if this is now also the one stopping my query from being applied. 

      Thanks again for taking the time to help!

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Anonymous , 

        When you want to combine number and text, you could try below M code

        = Table.AddColumn(#"Changed Type", "Custom", each [text column]&Number.ToText([number]))

         In addition, you also need to check whether there is any other error in your power query  

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.