Power BI Desktop - Cannot Convet to Numbers Error

[Paul21]

Hello Community,

Pwer Bi started trhowing me an error while I was to refrech a new set of data in the PBI file which has been working jst fine and still working with the old set of data.
Error is:

When I look in PBI Query Editor I find the folwoing erros but cannot find out how I can solve it.
I found Null values in nb_totes but even if I filter only numerical values data refresh is trowing the same error.

Your help would be highly appreciated

Paul

 

[RoryA]

Are you sure the error doesn't occur in an earlier step?

 

[Paul21]

Are you sure the error doesn't occur in an earlier step?

Hi RoryA, I do not know it.
The first error is showing upon refresh of data:

 

[RoryA]

You should select each step in the query from the start until you find the first one that returns an error. It looks as though the new data may be in a different format to the old data, since data starting with "NRCC" is clearly not numeric.

 

[Paul21]

RoryA - Thx for your support