Forum Discussion
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 older version of power bi
b) i eventually found "replace errors" and it doesn't work
Basically i'm trying to pull in a folder with pdf files. Each pdf varies in length, so if i have a query running for the 14th page and one of the files does not have page 14, it will return an error.
I discovered you can remove the error before the Transform File step.
11 Replies
What does the error say?
It seems like no matter what transformation i apply, that error will always appear. Again, this error comes from me trying to import the 14th page of a PDF for an entire folder, except this one file doesn't have 14 pages (instead it only has 11)
It seems like the Trasnfmorm File(2) is looking for the 14th page and hence whenever it is getting triggered, an error occurs.
Can you share the code of the Transform File(2) from Advanced editor?
Let's see if we cna make it dynamic.
Also, it woudl be better if you can share your sample file as it would be easier to troubleshoot.
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.
