Forum Discussion

BelenZ's avatar
BelenZ
Copper Contributor
Nov 16, 2023

Power Query in Mac for Sharepoint files

Hello, 

I am trying to get data in Power Query in Mac from an Excel file in Sharepoint. Is this possible with Excel for Mac? 

I only see the option "Sharepoint Online List" for not Sharepoint folder or file. 


Excel
Excel on Mac
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Nov 17, 2023

    Hi BelenZ 

     

    (I'm not a Mac user & don't have a SharePoint site)

    If you refer to Power Query data sources in Excel versions - section Excel for Microsoft 365 for Mac - the page currently says, re. SharePoint:

     

    If you go to subsequent page Import and shape data in Excel for Mac (Power Query), - section Refresh data sources - says:

     

    My interpretation/understanding: As you experience you cannot connect to and import data from a SharePoint File/Folder from a Mac. However, if you build your query to a SharePoint File/Folder from a PC you should be able to Refresh that query from your Mac
    ==> To be tested and confirmed here Please (this might help other Mac users)

Resources