Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Query error editor

Hallo everybody,   I have some rows that contains some simple errors. some colums have the number properties. in some of the rows are filled with -. This creates an error. so i want to replace - ...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".

 

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

i solved it in the source tabel. thats not the way but the way you suggested didn't work for me.

 

But everybody thanks for your patience with me.

i will change the data in the source tabel in excel and refresh power bi table.