Query Editor

[Anonymous]

Hi 

i am in query editor and i need to remove n/a which are somewhere in row no 1500 but query editor displays only 1000 rows..would like to know if there is any other option to remove such blanks feilds as it gives Data fomat error during saving .

And how do we resolve errors reported in query editor.

Thanks for your time 

Cheers

VB

[Anonymous]

i am in query editor and i need to remove n/a which are somewhere in row no 1500 but query editor displays only 1000 rows..would like to know if there is any other option to remove such blanks feilds as it gives Data fomat error during saving .

And how do we resolve errors reported in query editor.

Thanks for your time 

Cheers

VB

[v-cherch-msft]

Hi @Anonymous 

You may try to use Filter Rows and Remove Errors in query editor as below.

Reference:

https://docs.microsoft.com/en-us/power-query/power-query-quickstart-using-power-bi

https://docs.microsoft.com/en-us/power-query/power-query-tutorial-shape-combine

Regards,