Forum Discussion

arolon2's avatar
arolon2
Frequent Visitor
5 years ago
Solved

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, ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
5 years ago

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's avatar
    arolon2
    Frequent Visitor
    5 years ago

    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's avatar
      BA_Pete
      Super User
      5 years ago

      arolon2 

       

      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

      • arolon2's avatar
        arolon2
        Frequent Visitor
        5 years ago

        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?