Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Nick
Frequent Visitor

Getting SharePoint List items with full history version?

Hi,

 

We do have a SharePoint list to manage Fleet inventory of asset: mainly their attribution (who own it) and their status (active, lost, broken, etc.).

We did activated the SharePoint Version Control and I would like to use this information to run histroical report overtime around such assets status and ownership.

Right now, the only solution I found is to eitheir take a snapshot of the full list on a regular basis into another datasource.

Is there anyway to get such history/version data directly avoiding wruting such separate datasource?

 

Thansk in advance,

Nick

46 REPLIES 46

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. 

 
Thanks 
Evan

I 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?

I found a work around. Load the data into a DataFlow first. In your Dataflow there is an Options button. In there click Project Options. Check the box "Allow combining data from multiple sources. This could expose sensitive or cofidential data to an unauthorized person.". With that set the query can now pull the data from both SharePoint and WebContent.

@Greg_Deckler

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..

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.