Get Data from PDF option missing in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3072795%22%20slang%3D%22en-US%22%3EGet%20Data%20from%20PDF%20option%20missing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072795%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Microsoft%20office%20Student%20and%20Home%202019%20products.%20currently%2C%20I%20do%20not%20have%20an%20option%20to%20import%20the%20file%20as%20PDF%20in%20Powerquery.%20Can%20anyone%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sanju95_0-1643216199338.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342600iE37EC080DEDEFC94%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sanju95_0-1643216199338.png%22%20alt%3D%22Sanju95_0-1643216199338.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3072846%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Data%20from%20PDF%20option%20missing%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072846%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1287768%22%20target%3D%22_blank%22%3E%40Sanju95%3C%2FA%3E%26nbsp%3BI%20understand%20that%20it's%20only%20available%20to%20MS365%20subscribers%20and%20possible%20Excel%202021%20users.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have Microsoft office Student and Home 2019 products. currently, I do not have an option to import the file as PDF in Powerquery. Can anyone help me with this?

 

Sanju95_0-1643216199338.png

 

4 Replies

@Sanju95 I understand that it's only available to MS365 subscribers and possible Excel 2021 users.

Thanks... Can you tell me what additional features does MS365 has which is not there MS office Home and Student Version 2019. I need to see if its worth buying. Thanks

@Riny_van_Eekelen not getting this option even though I have a 365 subscription
What could be the cause? 

Screenshot 2022-03-04 at 6.29.03 PM.png

@MsinghIN Get Data (Power Query) from PDF is Windows only. Not for the Mac, I'm afraid.