Forum Discussion

pgoum's avatar
pgoum
Frequent Visitor
6 years ago

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