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

1 Reply

  • 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 https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-us&rs=en-us&ad=us - section Excel for Microsoft 365 for Mac - the page currently says, re. SharePoint:

     

    If you go to subsequent page https://support.microsoft.com/en-us/office/import-and-shape-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5, - 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