Forum Discussion
Unable to Remove Errors
I have a table which contains time-series data. I have errors appear in some rows, however don't seem to be able to remove them. I have tried Remove Errors, Replace Errors and Replace Values. I've ev...
I have solved this by moving the Table.RemoveRowsWithErrors() function to an earlier point in my Power Query, where the errors appear as single cells in one column (rather than expanded out to an entire row).
Anonymous
Just filter the data in by "Error" in edit query and then load/refresh the report.
Unfortunately this still did not work.
Hi!
I solved this by changing the API version during the data loading. I was using API version 14 and after changing this to v15 this error row was no longer there.
Somehow it's strange as I using in the same file v14 for other locations with no issues.
Hope it helps.
