Sudden "Can't convert to Number" error after removing blank rows

[RMDNA]

Hi all,

I have a table where I'm removing blank rows in Query Editor, and it gives the following error when trying to apply changes:

All that changes between it working just fine and throwing this error is removing those rows, but it shouldn't be trying to change any data types. Any help?

[v-juanli-msft]

Hi @RMDNA 

Do you have the Changed Type step after removing blank rows?

If so, please delete the Changed Type step.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RMDNA]

Hi @v-juanli-msft,

No, it doesn’t get added. Removing the rows is the last step in the edit history.