Power Query Get Data From SharePoint Folder Pre-2016?

[leishtheman]

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

 

[sandy666]

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

 

[leishtheman]

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

 

[sandy666]

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

 

[peter789]

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:

[LEFT][COLOR=#201F1E][FONT=&quot]Source = Excel.Workbook(Web.Contents("http://[I]fullpath to your sharepoint source[/I]"), null, true),

Peter
[/FONT][/COLOR][/LEFT]