Which M365 / Office Version to enable Get Data from Sharepoint Folder

[georg_f]

Hi Guys- would appreciate feedback from you - I'd like to use the "Get Data from Sharepoint" Option in PowerQuery, which is not showing at the moment.

We have Microsoft 365 Business Standard Licenses, Microsoft 365 Apps for Business - and Excel Desktop shows Microsoft Excel for Microsoft 365 MSO (Version 2207 Build 16.0):

Which options would I have / what do I have to purchase?

Found the table below - hence would be the best way to purchase Microsoft 365 Apps for Enterprise (in addition?) for the Users who want to edit / update the files?
Power Query data sources in Excel versions (microsoft.com)

Thanks & BR

[Daryl-Lynch-Bzy]

Hi @georg_f  - I am surprised that you cannot see this:

Can you please share a screenshot?

[georg_f]

Hi @Daryl-Lynch-Bzy thanks -
the Option from Online-Services (aus Online-Diensten in German Version) is greyed out in general.

[Daryl-Lynch-Bzy]

Hi @georg_f - Okay this suggest that your Microsoft account does not have SharePoint Online associated with it.  To fix you need to look at your Microsoft licensing.  Enterprise would be an option, but not necessarily your only option.  The question is best answered by Microsoft Licensing Experts instead.

[georg_f · Accepted solution]

I now found one option to get it working.

With Office 365 E3 license the option shows up => Microsoft Business Standard is not enough.

Maybe it would also work out with Microsoft Apps for Enterprise Alone (which is a bit cheaper), but for now I will stick with that.