Forum

Import from PDF via...
 
Notifications
Clear all

Import from PDF via Power Query in Excel -

3 Posts
2 Users
0 Reactions
240 Views
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

hi

I know I can import a PDF via PowerBI (in my version it's still in Beta) but can't see that option in Excel PQ? I am assuming it's *not* available for Excel PQ?

Thanks 

 
Posted : 27/08/2019 9:55 am
(@catalinb)
Posts: 1937
Member Admin
 

It's not available yet in Excel Power Query.

But you can try opening the PDF files in Word (Open With word, Word app will try to convert the PDF to a word document), then save as html (Single Web Page Document-mht or .mhtml), you should be able to import the html file as a "from web" document in Excel Power Query (provide the path to local .mht file instead of web address).

 
Posted : 27/08/2019 10:18 am
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

@Catalin - thanks for that. Will bear that in mind. Thank you so much and apologies for the delay in getting back 🙂

 
Posted : 21/09/2019 2:51 am
Share: