2 row got error when reload data , may i know how to clear ?

[Anonymous]

Hi All

Every time when i reload data , i will get 2 error , may i know how to clear the error ? i am okay to delete these 2 row of record , since the amount different , no one will be able to detect it.

[Anonymous]

Hi @Anonymous ,

You may check the related steps Table.TransformColumnTypes in The Advanced Editor.

Best Regards,

Stephen Tao

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

[Anonymous]

Hi sir

thank you for sharing. But the link I can not figure how it can help me.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I reproduced your problem.

I think this may be because there is a row of BECKHOFF BUS TERMINAL value in the INV column, and this value cannot be converted to a numeric type, so an error will be reported.

Try to convert the INV column to text type.

Best Regards,

Stephen Tao

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

[PhilipTreacy]

Hi @Anonymous 

Up to you if you want to remove the errors, but personally I wouldn't just ignore them, surely it's better to fix them? 

Your query is trying to convert text to a number.  Can't say why it's doing that without seeing your query/PBIX file and source data.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Hi @Anonymous ,

There is an option under edit query . Remove Rows--> Remove Errors.

Check it out if this helps.

Cheers

CheenuSing