Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
eddd83
Resolver I
Resolver I

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

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. 

 

eddd83_0-1653612709232.png

 

1 ACCEPTED SOLUTION

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

 

eddd83_0-1654104442667.png

 

View solution in original post

9 REPLIES 9
mahenkj2
Solution Sage
Solution Sage

Hi @eddd83,

Is it possible to post the sample pbix file?

 

eddd83
Resolver I
Resolver I

eddd83_0-1653670465175.png

 

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)

 

eddd83_0-1653696884902.png

 

PC2790
Community Champion
Community Champion

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

PC2790
Community Champion
Community Champion

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.

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?

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

 

eddd83_0-1654104442667.png

 

PC2790
Community Champion
Community Champion

What does the error say?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors