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?
Go to Solution.
Just found the solution - update Power BI to latest version, and there it (PDF import) is!
View solution in original post
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
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My Power BI Desktop doesn't have this option. Is it only available in Pro?
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.