Forum Discussion

eddd83's avatar
eddd83
Resolver I
4 years ago
Solved

Remove errors is not working

Firstly, i have already tried the following link: https://community.powerbi.com/t5/Desktop/How-to-remove-error-rows-Remove-error-option-not-working/td-p/652249  a) the instructions are based on an o...
Need Help
  • eddd83's avatar
    eddd83
    4 years ago

    I discovered you can remove the error before the Transform File step. 

     

     

Fidezuri1990's avatar
Fidezuri1990
Helper I
1 year ago

hi all,

just wanting to share my experience.

I tried to add a table into the power query that has different columns than the other tables from other files. I am doing this because I want all my files to be in one SharePoint folder. After the the table was added from the SharePoint folder, I had errors on other tables from other files because of the column differences. Refer to the figure below. The first row where it says Table is what I want, but the other files are showing errors.

I select the column Transform File (6), right-click and a window pop-up where I choose Remove Errors. And all the rows with Errors are gone. Leaving with me the table that I want. 

 

Hope this helps if you are trying to add tables with different columns or format from other files. Cheers.