Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.