Forum Discussion
Getting SharePoint List items with full history version?
Well, you can get version history like so:
http://<server>/<site>/_layouts/versions.aspx?list={litsID}&ID=<itemID>
Here are some resources that might assist:
http://stackoverflow.com/questions/24423657/sharepoint-2013-get-splistitem-versions-via-rest
Is there any update for this solution, considering this was a post from 2016?
These solutions work well in PBI Desktop but when publishing to the service I'm unable to refresh the dataset.
Hi, s-roberts ,
Try the solution suggested by Chris Webb here.
As I understand it, you need to hide away part of the API call's string from Power Query and append it during the run, so the code would look like this:
Web.Contents("<your-webpage>",[RelativePath = "<continuation of the API call>"])
I was able to pull in full version history and be able to set auto-refresh on the Service.
ThanksEvanI tweaked mine to use RelativePath and it still works fine from the Desktop but still fails to load with a refresh. I am using SharePoint online. Any tips?
Thanks but it looks I can only extract one version of a specific item. However thanks for sharing URLs: a solution may be around.
Guys did you had any luck extracting all version from the sharepoint list by any chances..
