Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |