When you have errors in your excel file, they sometimes leak through and adding "Table.ReplaceErrorValues" or "Table.RemoveRowsWithErrors" doesnt really work. What I have found is to add the error fix step right after the navigation step that loads the sheet.
In the screenshot below, I have used "Table.RemoveRowsWithErrors" after the Navigation step and it fixed the error.
No comments:
Post a Comment