Power Query Get Data From SharePoint Folder Pre-2016?

leishtheman

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

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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:
Upvote 0
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
 
Upvote 0
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:
Upvote 0
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]
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top