Nov 16 2023 11:02 AM
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.
Nov 16 2023 11:33 PM
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)