Results 1 to 5 of 5

Thread: Power Query Get Data From SharePoint Folder Pre-2016?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2007
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query Get Data From SharePoint Folder Pre-2016?

    Hello

    I've hooked an excel file up to a SharePoint folder on my o365 machine no problem.

    I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in.

    The add-in doesn't have 'From SharePoint Folder' available under 'From File' however. We can't figure out how to do it - From SharePoint List and From Web don't seem to work.

    Can anybody advise???

    Best regards,

    Andy

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,815
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query Get Data From SharePoint Folder Pre-2016?

    she can try From Other Source - From SharePoint List (I don't remember if it exist in add-in for 2013)
    or
    she can use PowerBi Desktop
    Last edited by sandy666; Jul 17th, 2019 at 08:53 AM. Reason: typo
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    Oct 2007
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Get Data From SharePoint Folder Pre-2016?

    We already tried using 'From Other Source - From SharePoint List' as it is present in 2013 - trouble is she doesn't get the 'Transform Data' button, which is the button I used in 2016 to actually access the contents of the folder - otherwise all you get is filenames and not a lot else?

    Thanks

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,815
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query Get Data From SharePoint Folder Pre-2016?

    sorry mate but I used PQ add-in long time ago,
    and even I don't know what does she see after... maybe there is something to Expand (any Binaries?)

    so you need to wait for someone else or google it
    or as I said before: PowerBI Desktop
    Last edited by sandy666; Jul 17th, 2019 at 09:34 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    Board Regular
    Join Date
    Nov 2016
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Get Data From SharePoint Folder Pre-2016?

    Andy,
    Does it work if you just paste the code you're using in O365 into the older query in advanced editor.
    Possibly something like:
    Code:
    Source = Excel.Workbook(Web.Contents("http://fullpath to your sharepoint source"), null, true),


    Peter

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •