Forum Discussion
Power Query skipping wrapped text from PDF's Column Headers causing Null values in that column
Hi, I am importing from folder that contain invoices stored as PDFs. The format on page 2 of the invoice is a table that contains the line items I need to import. I always chose page 2 from first fil...
Hello PowerPaul ,
Basically your requirement is to automate the task even it may present wrapped column header at any column or just need to fix this maually each time.
Hi Jayasalvan, I would like the process to be automatic. I want to drop the new invoice in the folder and refresh my query to retrieve the new data. It varies month to month and I never know when the text in the columns will be wrapped or not.
Also, I am using Excel power query for this task. The plan is to keep the data in excel and then upload to power bi.
Thank you