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 f...
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 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