Forum Discussion
Convert pdf to excel
Hello, I have gone to the data option to convert a pdf to excel, and no option is listed. Am I looking at the wrong place? Thanks
Thanks for getting back to me. I contacted Microsoft support and this option was tried but did not worked. I have Professional 2019 so I am surprised it does not work. However, Customer Support showed me a different route using Word.
It's a shame I cannot use the excel option.
Thanks again.
It's a shame I cannot use the excel option.
Thanks again.
Ref. to https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-us&rs=en-us&ad=us it's expected you don't have the option in the menu with 2019 Pro or Pro Plus. Note that the page also indicates that .NET 4.5 or higher is also required
I contacted Microsoft support and this option was tried but did not worked
Are you saying that - after refreshing the query shared with https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d?tm=1657958531852 - you got the following?:
If you did make sure your system has .NET 4.5 or higher version and try again...