Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.