query errors

gtamir · ‎09-03-2018

Hi,

I have errors in the table. I know that there is an "*" in phone column.

Why there is no error query? Why the error is displayed on all the columns?

Thanks Giora

Greg_Deckler · ‎09-03-2018

I would just replace your * with blank (null) value.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

gtamir · ‎09-03-2018

Yes this is what I would normaly do. But there are other characters spred out there and I don't know where.

Why there is no query error? And why the word error is on all the fields.

gtamir · ‎09-03-2018

By the way, I don't load this table(YarpaCustomers) to the model because I want to append another file to it.

Is this the reason I don't get query error? If yes what to do to clean the table?

Helpful resources