Forum Discussion
Retrieve SharePoint on-premise List versions
Hey!
I have established a connection with a sharepoint on-premise list for which I would like to retrieve all versions of a column. I am looking for a workaround within Power BI and based on this post here I created the suggested function and invoked in into my query as below. I give the list's name "Shift Reports Master", the list's location 'http://XXXX:40736/sites/Energy/EnergyAgNikolaos' and the column "Id" of my query.
Then I receive the following error message:
DataSource.Error: Web.Contents failed to get contents from 'http://XXXX:40736/sites/Energy/EnergyAgNikolaos/_api/web/Lists/getbytitle('Shift%20Reports%20Master')/items(13)/versions' (404): Not Found
Details:
DataSourceKind=Web
DataSourcePath=http://XXXX:40736/sites/Energy/EnergyAgNikolaos/_api/web/Lists/getbytitle('Shift%20Reports%20Master')/items(13)/versions
Url=http://XXXX:40736/sites/Energy/EnergyAgNikolaos/_api/web/Lists/getbytitle('Shift%20Reports%20Master')/items(13)/versions
List's url: "http://XXXX:40736/sites/Energy/EnergyAgNikolaos/Lists/Group%20Reviews%20Master/AllItems.aspx"
I have also tried "Group Reviews Master" as the list's name but didn't work. Any thoughts are welcome 😊
Thanks,
Panos
1 Reply
- IceyCommunity Support
Hi pgoum ,
Sorry, I know very little about this.
Hope Greg_Deckler amitchandak could help you.
Best Regards,
Icey