Error converting data type nvarchar to numeric

Hi willclein , I am having this exact same issue:

I'm having trouble importing data sources where I'm getting the above error message. When I import two views from my SQL database (each view is for a separate year), I don't have any issues in Power Query Editor. When I try to append one to the other, I sometimes get the above error. 

I even went a step further and explicilty casted the field in question. Everything loads fine in the power query editor, but whenver I try to apply the changes in the report view it bombs out every time with the same error you experienced. Were you able to resolve this issue another way, or do you have a support case w/ MSFT? Thanks