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?
I would just replace your * with blank (null) value.
Proud to be a Datanaut!
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.
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?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.