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

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

  • 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.