Forum Discussion
Get data from PDF is not displayed in Power Query
- Hello,
I am using Excel 2016, Windows, and option to get data from PDF is not displayed in Power Query. Any ideas how to resolve it?
Thank you.
Since you are not having higher version of Excel, Use Power BI Desktop which is free and can be installed from
Here, you can work with your pdf document, transform the data in Power BI Desktop, then you can right click on your table name on right - Copy table and paste into Excel (there are many ways to get data into Excel but this is the simplest)
2 Replies
- Greg_DecklerCommunity Champion
NASCH Use Excel 2019 or some version of office that is not over half a decade old?
- Vijay_A_VermaMost Valuable Professional
Since you are not having higher version of Excel, Use Power BI Desktop which is free and can be installed from
Here, you can work with your pdf document, transform the data in Power BI Desktop, then you can right click on your table name on right - Copy table and paste into Excel (there are many ways to get data into Excel but this is the simplest)