Power Query Get Data From SharePoint Folder Pre-2016?

leishtheman

New Member
Joined
Oct 1, 2007
Messages
25
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,782
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:

leishtheman

New Member
Joined
Oct 1, 2007
Messages
25
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

Well-known Member
Joined
Oct 24, 2015
Messages
5,782
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:

peter789

Board Regular
Joined
Nov 20, 2016
Messages
114
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:
[LEFT][COLOR=#201F1E][FONT=&quot]Source = Excel.Workbook(Web.Contents("http://[I]fullpath to your sharepoint source[/I]"), null, true),
Peter
[/FONT][/COLOR][/LEFT]
 

Watch MrExcel Video

Forum statistics

Threads
1,102,378
Messages
5,486,517
Members
407,550
Latest member
LucasBordure

This Week's Hot Topics

Top