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.
Hi,
I've been asked how to importing selected data from a PDF into Power Query. I've been using a simple file with the following table in it
the file is at https://1drv.ms/u/s!AmxJyApgEAcYgspl_8eZQm65GwmioQ
I found some instructions at https://powerbloggerbi.com/2016/03/10/power-query-import-pdf/:
but I can't get them to work fully: at step 8, after importng and expanding children, I get the following:
I need to get from this to a formatted table showing the actual data - can anyone help?
Thanks!
Solved! Go to Solution.
Just found the solution - update Power BI to latest version, and there it (PDF import) is!
Hi @Anonymous
As tested, i meet the same problem as you did.
Do you know we can connect to a pdf file directly with Power BI Desktop?
We could also select which pages to connect to.
Connect to a PDF file in Power BI Desktop
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
My Power BI Desktop doesn't have this option. Is it only available in Pro?
Just found the solution - update Power BI to latest version, and there it (PDF import) is!
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.