Jan 02 2022 03:34 AM
hi all,
i am new to excel and id like to add an api to one of my sheets, however even tho i have 2016 excel version there is no get and transform data for me which is what id really need.
can anyone help me understand why its just not there? even tho i have 2016 version?
thanks
Jan 02 2022 03:50 AM
Jan 02 2022 04:01 AM
Jan 02 2022 04:21 AM
Jan 02 2022 04:57 AM
If upgrade I'd suggest on Excel 365 or at least on Excel 2021. Concrete channel/version depends on needs. You may check here Power Query data sources in Excel versions (microsoft.com) which connectors are available for each version.
Jan 02 2022 05:26 AM
Jan 02 2022 05:44 AM
Jan 02 2022 06:21 AM
SolutionI'm not familiar with consumer versions. In general on subscription model ( Microsoft 365 ) you always have the latest functionality compare to similar perpetual version. The latest has fixed functionality and updating only bug fixes and security patches.
On Microsoft 365 set of features depends on subscription level and distribution channel. Enterprise has the richest functionality, other levels we have to check.
Distribution channel means how often functionality is updated. On insider (beta) channel you have updates every week, on semi-annual channel - twice per year. Good news you may shift from one channel to another at any time, that's free of charge.
As for Power Query on Personal - most probably it's available, but I'd double check. You may install trial version (one month as I remember), check if that's what you need and only after that pay for the subscription.
Jan 02 2022 02:14 PM
Jan 03 2022 12:59 AM
@DanTN123 , you are welcome, good luck with Excel 365
Jan 13 2022 11:23 AM
Jan 14 2022 08:29 AM
It's better to start new conversion from here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral. Yes, screenshot will help.
Jul 22 2022 07:01 AM
Jul 22 2022 08:47 AM
From the link you sent on Mac are available only two connectors
All the rest is ability to refresh quires created on another platform. However, I'm not Mac user, perhaps @Riny_van_Eekelen could clarify.
Jul 22 2022 08:55 AM
@Sergei Baklan At present, Excel for Mac (Insider, Beta) supports the following connectors:
Jul 22 2022 09:40 AM
Thank you, nice to know. I guess depends on channel.
Jan 02 2022 06:21 AM
SolutionI'm not familiar with consumer versions. In general on subscription model ( Microsoft 365 ) you always have the latest functionality compare to similar perpetual version. The latest has fixed functionality and updating only bug fixes and security patches.
On Microsoft 365 set of features depends on subscription level and distribution channel. Enterprise has the richest functionality, other levels we have to check.
Distribution channel means how often functionality is updated. On insider (beta) channel you have updates every week, on semi-annual channel - twice per year. Good news you may shift from one channel to another at any time, that's free of charge.
As for Power Query on Personal - most probably it's available, but I'd double check. You may install trial version (one month as I remember), check if that's what you need and only after that pay for the subscription.