Register
Log In
Unanswered
Home
New Member
May 4, 2016
Offline
Not Sure, if we can import data of PDF (containing tables) through Power Query so that it can be analysed further.
Dashboards
Power BI
Power Query
April 21, 2015
Offline
From my experience in general: it is possible to import data from pdf files, but you need to customize before going further with it.
It depends on how the data is organized in the pdf. Most of the time you can copy-paste tables into Excel (not sure if all pdf's can be directly imported and if that's possible you neet to customize it as well) and after that work on what you got to bring it further. Not all pdf's are 'open' however. Sometimes the file is protected against copying.
Let us hear about your results!
November 8, 2013
Offline
Power Query will import from most database formats, text files, excel and csv files. PDF format is not supported.
You have to convert the PDF to excel, there are even online converters, you will be able to use the converted file in PQ.
Of course, if the conversion is accurate, with no errors.
Most Users Ever Online: 57
Currently Online: Mynda Treacy
18 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
