Forum Discussion
Losing a column when importing PDF
I'm working with a folder where I have some PDFs, all with the same structure. I've developed a function to just upload the files to that folder and automatically apply all transformations and oper...
Are all columns coming in, but your M code isn't handleing a 2 or 3 column table depending on the file? If so, check out this blog post. Removing/Selecting Columns - Pitfall #5 in #PowerBI and #PowerQuery - DataChant - particularly the MissingField.Ignore discussion.
Depending on the file (all have the same structure) it recognizes 2 or 3 tables.
When there are 2 tables there are no problems, but when it recognizes 3 there is a column that is not loaded I don't know why. It's not that I deleted it during transformation or something like that, it is missing from the beginning.