Forum Discussion

JonasCosta's avatar
JonasCosta
New Member
10 months ago

Excel - Connect to a folder using online link

When I connect Power Query to a .XLSX file, I can open it and copy the path ("https://xxxxxx.sharepoint.com/sites/")
Then in the PQ: "Excel.Workbook(Web.Contents("https://xxxx.Sharepoint....)"
How can I do the same, but to a folder ?

I can Only connect to a local folder >> Folder.Files("C:\Users..... To reald all files inside. 

The problem with local path is that the query works only in my PC. IF I try in another one, i have to change the path.
I think online Path can solve this. 

I Can't find Shapoint Option to connect to:

 

Need Help

7 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    10 months ago

    Hi JonasCosta ,

     

    In the Get Data dialog, use the SharePoint Folder connector.


    In Excel, you can get there like this:

     

    Pete

     

    • JonasCosta's avatar
      JonasCosta
      New Member
      10 months ago

      Hello BA_Pete !

      Thank you for your answer!

      I can't find the "From sharepoint folder" option.
      Maybe that's something related with my Office Version. I'm using Microsoft 365.
      I looked for some option to enable but cant't find.

      Do you know something abou that ?

       

      • BA_Pete's avatar
        BA_Pete
        Super User
        10 months ago

         

        Hmm, that's odd. I would have thought your Excel would auto-update if you're on M365.

         

        Here's the version I'm using for reference:

         

        And here's the basic connection string that PQ generates to connect to a folder, so you can try just copy/pasting into Advanced Editor:

        let
    Source = SharePoint.Files("https://ORGNAME.sharepoint.com/sites/SHAREPOINTSITENAME/", [ApiVersion = 15])
in
    Source

         

        Pete

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    10 months ago

    Hi JonasCosta 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    10 months ago

    Hi JonasCosta 

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    10 months ago

    Hi JonasCosta 

    As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

     

    Thanks and regards