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. 

     

     

PC2790's avatar
PC2790
Community Champion
4 years ago

Try:

 

let
Source = (Parameter2) => let
Source = Pdf.Tables(Parameter2, [Implementation="1.3"]),
Page1 = Source{[Id="Page013"]}[Data]
in
Page1
in
Source

 

I think thsi will avoid the error however the page 14 will not be included in further transformations.

Please try once.

eddd83's avatar
eddd83
Resolver I
4 years ago

This is problematic because each pdf could have a different number of pages. Is there a way to create a variable or something, so that it can import the maximum number of pages?

  • eddd83's avatar
    eddd83
    Resolver I
    4 years ago

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

     

     

    • massett83's avatar
      massett83
      Regular Visitor
      1 year ago

      FGD... THANK YOU!   this fixed a general #Ref error i've been trying to filter out in the large series of files I am querying.