|Error Message

[ColMac]

I'm getting an error in the Power Query Editor in the last line of an import from a folder containing pdf files.

The fileds clearly say error, but REMOVE ROWS>REMOVE ERRORS has no effect on this row. If I click on the row, I get the attached error message

Any suggestions on how to handle this please

?

 

[Matt Allington]

When you do a file combine, the first file in the folder is used as the sample file. You teach PQ how to process the sample file, then it repeats the same process for all files.

Understanding Power Query Combine

Level: Intermediate Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data). The new capability makes it easier to combine multiple copies of similar workbooks into a single table without hand...

exceleratorbi.com.au

the error you posted occurs when one of the files cannot be processed. You can see in the error it is looking for a table called Table002 and can’t find it. One of your PDFs is missing this table, and hence can’t be processed. To find it, keep the file name column (my guess is you removed it) to see which file creates the error.

 

[ColMac]

When you do a file combine, the first file in the folder is used as the sample file. You teach PQ how to process the sample file, then it repeats the same process for all files.

Understanding Power Query Combine

Level: Intermediate Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data). The new capability makes it easier to combine multiple copies of similar workbooks into a single table without hand...

exceleratorbi.com.au

the error you posted occurs when one of the files cannot be processed. You can see in the error it is looking for a table called Table002 and can’t find it. One of your PDFs is missing this table, and hence can’t be processed. To find it, keep the file name column (my guess is you removed it) to see which file creates the error.

A perfect explanation of the problem and the solution. Many thanks. I also marked that link to read next. I have watched a few tutorials already before starting my project. The good ones are a great way to learn.

Thanks again


Colin