Forum Discussion
Importing a folder from Sharepoint
Hello,
I am attempting to import a Sharepoint folder that contains .xlsx files. I am clicking on Get Data -> More -> Sharepoint Folder. When asked for the site URL I go to the sharepoint folder, click on the ellipsis, and use the Get a Link option.
When I use the restricted link I receive the following message:
If I use the view link the message is:
I have access to view and edit the folder under my windows/org login but am not able to import. What am I missing?
5 Replies
Hi arolon2 ,
When you select SharePoint Folder as a new source, the URL that you put in the dialog should be in this format:
https://yourOrganisationName-my.sharepoint.com/personal/your_account_email_address/Note the underscores in your_account_email_address that replace any special symbols (@, dot, dash etc.).
When the next dialog appears, you want to select Microsoft account on the left, then select the level in the dropdown box to the one that fully includes your account email address at the end.
This should get you to the Combine & Transform / Transform option dialog. Once you import this into Power Query, you can navigate to the exact SharePoint folder you need by expanding the embedded Tables.
Pete
Not 100% on waht you mean by noting the underscores. Tried putting my email address in that spot and still got a 404 error.
Sorry, probably didn't explain that very well.
So, if your MS account email address that you log into SharePoint/O365 with is
[email protected], this becomes my_name_some_company_co_uk
Pete
