Importing a folder from Sharepoint

[arolon2]

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?

[BA_Pete]

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

[arolon2]

Not 100% on waht you mean by noting the underscores. Tried putting my email address in that spot and still got a 404 error.

[BA_Pete]

@arolon2 

Sorry, probably didn't explain that very well.

So, if your MS account email address that you log into SharePoint/O365 with is

my.name@some-company.co.uk, this becomes my_name_some_company_co_uk

Pete

[arolon2]

Still recieved a 404 error. Also the sharepoint folder I am trying to import from is a shared folder, not personal. Unsure how that URL would help and not the URL I get when I click on the folders ellipses in Sharepoint.

Update: So I have been able to link the home folder in sharepoint. My issue is that I am trying to link to a subfolder in it. Am I able to do this?

[BA_Pete · Accepted solution]

@arolon2 ,

Yes, I believe once you import the Home Folder using the Get Data process, you should be able to filter the [Folder Path] field to only show rows within your chosen folder.

Pete