Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I need to extract data from a pdf table on a quarterly basis and this time Power Query reads out the heading in a Column 11 instead of Column 10. Is there any chance to get the first two rows back to column 10? The issue is that the following rows are in correct order. I would be pleased to get some tips on how to handle this.
Screenshot of original pdf file
Original Query
New Query
Solved! Go to Solution.
Hi Joyce,
thank you so much. This worked well for me 🙂