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. 

     

     

eddd83's avatar
eddd83
Resolver I
4 years ago

 

  • eddd83's avatar
    eddd83
    Resolver I
    4 years ago

    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)

     

     

    • PC2790's avatar
      PC2790
      Community Champion
      4 years ago

      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.

      • eddd83's avatar
        eddd83
        Resolver I
        4 years ago

        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