Forum

Can PowerQuery comb...
 
Notifications
Clear all

Can PowerQuery combine all PDF copies and transform into single excel spreadsheet?

3 Posts
2 Users
0 Reactions
84 Views
(@caroltxy)
Posts: 17
Eminent Member
Topic starter
 

i have thousand over PDF in standard format and wish to transform into single excel spreadsheet for analysis purpose. 

 

May i know if power query able to do that? if not, what kind of alternative tool willing to do that? Power Pivot? Power BI desktop etc? 

 
Posted : 18/04/2020 11:54 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi,

Power BI desktop has an option to import data from PDF files. Use the From Folder option, and make sure you have those pdf files in that folder.

If the structure is not the same in all files, will not be reliable.

 
Posted : 18/04/2020 1:08 pm
(@caroltxy)
Posts: 17
Eminent Member
Topic starter
 

thanks alo

Catalin Bombea said
Hi,

Power BI desktop has an option to import data from PDF files. Use the From Folder option, and make sure you have those pdf files in that folder.

If the structure is not the same in all files, will not be reliable.  

thanks alot!

 
Posted : 21/04/2020 11:42 am
Share: