Oct 26 2023 01:56 AM
Hi everyone,
I have already searched the forum for a solution to my problem, but nothing seems to work.
I would like to import, via Power Query, data contained in Excel files saved on Sharepoint. I have Excel for Mac.
I found similar questions, but none of the proposed solutions seem to work for me.
I have a Microsoft 365 Business Premium account.
Thank you
Oct 28 2023 03:15 AM
The process of connecting Excel for Mac to a file saved in SharePoint using Power Query can be a bit different from the Windows version of Excel. However, I can provide you with a general guideline on how to achieve this using Excel for Mac. Please note that the specific steps may have changed with updates to the software, so you may need to refer to Microsoft's latest documentation or consult with your IT department for the most current guidance.
Here are the general steps to connect Excel for Mac to a file in SharePoint using Power Query:
Please note that the exact wording and options in Excel for Mac may vary depending on the version and updates. If you encounter any issues, ensure that your version of Office is up to date. Additionally, you might find the "Get & Transform Data" feature in Excel for Mac useful for data import and transformation tasks, especially when dealing with data from external sources like SharePoint. Since no one has replied to this for over a day and more, I entered your question in various AI's. The text and the steps are the result of the compilation of different AI's.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Apr 11 2024 12:51 PM
I am experiencing a similar issue. On the Windows platform, I establish a connection between my Excel application and Excel files located on SharePoint using Power Query, and the process functions seamlessly. However, upon attempting to replicate this on a Mac platform, I encounter an error message indicating the following:
Upon attempting to sign in, the system fails to recognize my organization's sign-in credentials.