Forum Discussion
NinoN4516
Dec 10, 2020Copper Contributor
Excel power query not showing get data from PDF
Hi all I have an active MS OFFICE 365 personal subscription. I wish to import PDF documents using power query, but i do not have the option when I activate the from file dropdown in get and transf...
SergeiBaklan
Dec 11, 2020Diamond Contributor
Perhaps you are on semi-annual channel, I'm not sure if this connector is already available on it. You may try to switch on another channel. Most probably for the Personal it could be done directly from File->Account.
MCD881000
Nov 06, 2021Copper Contributor
Hi Sergei, I am having the same problem being Get Data (Power Query) does not go on to File> PDF. I have Microsoft 365 Subscription. I have looked for File-> Account to see if I could change the channel and cannot find this path. I update regularly my Microsoft 365. Please help. I need this great function.
- SergeiBaklanNov 06, 2021Diamond Contributor
Are you on Windows or Mac ?
- MCD881000Nov 06, 2021Copper ContributorWow, Sergei, thank you for the fast response.
Mac.- Riny_van_EekelenNov 06, 2021Platinum Contributor
MCD881000 Mac! That explains it. Power Query is NOT available on the Mac how you would want it to be. What you see under the Get Data (Power Query) button is a first step towards what some day might happen. On a Mac you can NOT create or edit existing queries like on a PC. Consider setting up a virtual PC with Excel for Windows on your Mac (via Bootcamp or Parallels). That's what I do. It opens up the full Excel spectrum to you.