Excel - Get Data from PDF is Missing

%3CLINGO-SUB%20id%3D%22lingo-sub-2114009%22%20slang%3D%22en-US%22%3EExcel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22trobinson-q2_0-1612391092428.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252117i36B05CCDD6A88F89%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22trobinson-q2_0-1612391092428.png%22%20alt%3D%22trobinson-q2_0-1612391092428.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20users%20that%20are%20reporting%20that%20up%20until%20a%20couple%20weeks%20ago%2C%20they%20were%20able%20to%20import%20data%20from%20a%20pdf%20from%20this%20menu.%20That%20feature%20is%20now%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20licensing%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22trobinson-q2_1-1612391147401.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252118i8D026847B52C27FE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22trobinson-q2_1-1612391147401.png%22%20alt%3D%22trobinson-q2_1-1612391147401.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20why%20would%20this%20feature%20be%20missing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2114009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114783%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954215%22%20target%3D%22_blank%22%3E%40trobinson-q2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20Home%20version%20is%20quite%20full%20functional.%20The%20difference%20with%20business%2Fenterprise%20subscriptions%20is%20mainly%20in%20licensing%20-%20in%20brief%20you%20are%20not%20allowed%20to%20earn%20money%20with%20Home%20subscription.%20You%20shall%20do%20business%20using%20business%20subscription.%20I%20simplified%20a%20bit%2C%20nonetheless.%20You%20may%20check%20availability%20by%20SKU%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhere%20is%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3BWithin%20SKU%20availability%20depends%20on%20the%20channel%20you%20are%20subscribed.%20And%20more%20exactly%20on%20version%20within%20such%20channel%20(semi-annual%20has%203%20versions).%20Thus%20you%20have%20to%20compare%20SKU%2C%20channel%20and%20it's%20version%20to%20compare%20functionality%2C%20plus%20some%20time%20for%20the%20deployment.%20Just%20%22I'm%20on%20Office%20365%22%20is%20not%20enough.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20deployment%20of%20new%20functionality%20to%20all%20Office365%20subscribers%2C%20from%20first%20Beta%20users%20to%20slowest%20semi-annual%20channel%20users%20could%20take%20couple%20of%20years.%20If%20you'd%20like%20to%20have%20new%20functionality%20faster%20you%20need%20to%20change%20the%20channel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20yes%2C%20Microsoft%20could%20deploy%20some%20new%20functionality%20and%20in%20a%20while%20cancel%20it%20due%20to%20some%20critical%20bugs.%20But%20that%20happens%20quite%20seldom%20and%20not%20on%20semi-annual%20channel.%20For%20such%20changes%20it's%20not%20necessary%20to%20update%20the%20build%2C%20it's%20enough%20if%20you%20connected%20to%20internet.%20Switching%20functionality%20on%2Foff%20is%20done%20by%20licensing%20manager%20assuming%20such%20functionality%20code%20is%20within%20your%20current%20build.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114732%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk%2C%20that's%20good%20knowledge%20to%20have.%20Thank%20you%20for%20the%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20doesn't%20tell%20me%20why%20my%20users%20are%20saying%20that%20had%20this%20feature%20and%20then%20it%20was%20gone.%20Was%20it%20a%20feature%20Microsoft%20had%20to%20remove%20and%20now%20they're%20getting%20it%20back%3F%20I've%20had%203%20user%20all%20start%20yelling%20at%20me%2C%20asking%20why%20this%20function%20is%20suddenly%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20I%20also%20checked%20with%20our%20programmer.%20He%20has%20a%20home%20Office%20365%20yearly%20subscription%20and%20has%20the%20Get%20Data%20From%20PDF%20feature.%20Are%20the%20home%20versions%20different%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114682%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114682%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954215%22%20target%3D%22_blank%22%3E%40trobinson-q2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20on%20semi-annual%20channel%20which%20is%20updated%20with%20new%20functionality%20twice%20per%20year%2C%20in%20Jan%20in%20Jul.%20Monthly%20Enterprise%20channel%20was%20updated%20with%20PDF%20connector%20in%20Oct%202020%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fmonthly-enterprise-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20notes%20for%20Monthly%20Enterprise%20Channel%20releases%20in%202020%20-%20Office%20release%20notes%20%7C%20Microsoft%20Docs%3C%2FA%3E%26nbsp%3B%2C%20semi-annual%20shall%20be%20updated%20few%20months%20later%20and%20I%20didn't%20find%20PDF%20connector%20in%20Jan%20update%20for%20that%20channel%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-enterprise-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20notes%20for%20Semi-Annual%20Enterprise%20Channel%20releases%20in%202020%20-%20Office%20release%20notes%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EThus%20you%20shall%20wait%20till%20July%20or%20upgrade%20on%20Monthly%20Enterprise%20or%20Current%20channels.%20That's%20free%20of%20charge%20and%20above%20channels%20are%20stable%20enough.%20However%2C%20which%20channel%20to%20use%20depends%20mostly%20on%20your%20organization%20ITS%20policies%2C%20are%20they%20ready%20to%20provide%20more%20or%20less%20new%20functionality%20to%20end%20users%20or%20prefer%20to%20wait%20couple%20of%20years%20till%20all%20possible%20fixes%20will%20be%20deployed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114114%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22trobinson-q2_0-1612456247874.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252283i572EC32DDF4BA033%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22trobinson-q2_0-1612456247874.png%22%20alt%3D%22trobinson-q2_0-1612456247874.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20updating%20Office%2FExcel%2C%20but%20it%20says%20we're%20up%20to%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114101%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954215%22%20target%3D%22_blank%22%3E%40trobinson-q2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20more%20picture%20is%20missing%20-%20on%20which%20channel%20you%20are.%20It%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20529px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252280iF0803306A545B401%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2465481%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465481%22%20slang%3D%22en-US%22%3EHi%20trobinson-q2%3CBR%20%2F%3EI%20have%20same%20issue%20with%20my%20Excel%20(Get%20Data%20from%20PDF%20is%20Missing)%2C%20did%20you%20resolve%20your%20problem%3F%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3ETony%20Hu%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2465889%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1083652%22%20target%3D%22_blank%22%3E%40tonyhusynopsys%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20which%20subscription%20and%20channel%20you%20are%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466114%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Get%20Data%20from%20PDF%20is%20Missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tonyhusynopsys_0-1624282314828.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290277iB16AB4EEE8CF089A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tonyhusynopsys_0-1624282314828.png%22%20alt%3D%22tonyhusynopsys_0-1624282314828.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

trobinson-q2_0-1612391092428.png

I have users that are reporting that up until a couple weeks ago, they were able to import data from a pdf from this menu. That feature is now missing.

 

We have licensing:

trobinson-q2_1-1612391147401.png

 

So, why would this feature be missing?

 

11 Replies

@trobinson-q2 

One more picture is missing - on which channel you are. It looks like

image.png

@Sergei Baklan 

trobinson-q2_0-1612456247874.png

 

I've tried updating Office/Excel, but it says we're up to date.

 

@trobinson-q2 

You are on semi-annual channel which is updated with new functionality twice per year, in Jan in Jul. Monthly Enterprise channel was updated with PDF connector in Oct 2020 Release notes for Monthly Enterprise Channel releases in 2020 - Office release notes | Microsoft Doc... , semi-annual shall be updated few months later and I didn't find PDF connector in Jan update for that channel Release notes for Semi-Annual Enterprise Channel releases in 2020 - Office release notes | Microsoft...

Thus you shall wait till July or upgrade on Monthly Enterprise or Current channels. That's free of charge and above channels are stable enough. However, which channel to use depends mostly on your organization ITS policies, are they ready to provide more or less new functionality to end users or prefer to wait couple of years till all possible fixes will be deployed.

@Sergei Baklan 

Ok, that's good knowledge to have. Thank you for the response.

 

However, it doesn't tell me why my users are saying that had this feature and then it was gone. Was it a feature Microsoft had to remove and now they're getting it back? I've had 3 user all start yelling at me, asking why this function is suddenly missing.

 

EDIT: I also checked with our programmer. He has a home Office 365 yearly subscription and has the Get Data From PDF feature. Are the home versions different again?

@trobinson-q2 

Yes, Home version is quite full functional. The difference with business/enterprise subscriptions is mainly in licensing - in brief you are not allowed to earn money with Home subscription. You shall do business using business subscription. I simplified a bit, nonetheless. You may check availability by SKU here Where is Get & Transform (Power Query) - Excel (microsoft.com)

 Within SKU availability depends on the channel you are subscribed. And more exactly on version within such channel (semi-annual has 3 versions). Thus you have to compare SKU, channel and it's version to compare functionality, plus some time for the deployment. Just "I'm on Office 365" is not enough.

 

In general deployment of new functionality to all Office365 subscribers, from first Beta users to slowest semi-annual channel users could take couple of years. If you'd like to have new functionality faster you need to change the channel.

 

And yes, Microsoft could deploy some new functionality and in a while cancel it due to some critical bugs. But that happens quite seldom and not on semi-annual channel. For such changes it's not necessary to update the build, it's enough if you connected to internet. Switching functionality on/off is done by licensing manager assuming such functionality code is within your current build.

Hi trobinson-q2
I have same issue with my Excel (Get Data from PDF is Missing), did you resolve your problem?
Regards,
Tony Hu

@tonyhusynopsys 

On which subscription and channel you are?

@tonyhusynopsys 

Build number says practically nothing. Is that semi-annual channel? If so which one? It shall be here

image.png

On semi-annual most probably this functionality is not deployed so far.

@Sergei Baklan Issue seem to persist and be spreading across users. A friend had use the function just yesterday and today even while on the same Current channel and version, option is now missing. What do you think?

@Tobechukwu 

If it appeared only yesterday I'd wait a day or two, it could appear after couple of reboots.