Forum Discussion
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...
I discovered you can remove the error before the Transform File step.
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.
Here's the advanced editor for Trasnfmorm File(2)
let
Source = (Parameter2) => let
Source = Pdf.Tables(Parameter2, [Implementation="1.3"]),
Page1 = Source{[Id="Page014"]}[Data]
in
Page1
in
Source