Forum Discussion

georg_f's avatar
georg_f
Frequent Visitor
4 years ago
Solved

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

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

Need Help
  • georg_f's avatar
    georg_f
    4 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

     

    Can you please share a screenshot?

     

    • georg_f's avatar
      georg_f
      Frequent Visitor
      4 years ago

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.