error messages when applying changes

[Anonymous]

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?

[dax · Accepted solution]

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]

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]

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!

[tex628 · Accepted solution]

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

[Anonymous]

Okay understood, Thing is. Why does this only pop up when selecting "keep rows"> keep all with errors.

Because this error message does not show up at any time before I try this option?

[tex628]

I'm not entirely sure but my guess is that power query attempts to perform the action of keeping only error rows but can not complete that action due to another error. 

[dax · Accepted solution]

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.