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,
Well, you can get version history like so:
Here are some resources that might assist:
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.
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.
Thanks but it looks I can only extract one version of a specific item. However thanks for sharing URLs: a solution may be around.
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates