Forum Discussion
Getting SharePoint List items with full history version?
JensG cool that you posted a function/query. Unfortunately, it does not work for me. Any ideal how I can fix that without too much effort. The error says Expression.Error: The access to the ressourc is prohibites (translated from my version: "Der Zugriff auf die Ressource ist untersagt."). I checked that I am properly logged in and check the list that there are no permission restrictions. At least I cannot see any. I am assuming that the account I am logged into PowerBI must also have access the SharePoint list or is there anything else I need to consider?
Are you sure that the links in your function are still valid?
http://schemas.microsoft.com/ado/2007/08/dataservices/metadata
http://schemas.microsoft.com/ado/2007/08/dataservices
Appreciate, if someone has a clue what is wrong with it?
Thank you so much
Hi udobausc,
sorry I don´t have seen this error on my end yet.
I´m logged in with my O365 Users in Power BI, same user who has access to the SP stuff.
Anyhow sometimes Power BI is promting to enter credentials where I can select differrent methods. But I always use the same user.
regarding the old links, it is when I expand some columns this is returned as field name and I have just kept it as it comes from the SP API :-)
it might be worth to check if the underlying link is working in your browser when you replace the values in <>:
<VersionsRelevantSharePointLocation>/_api/web/Lists/getbytitle('<VersionsRelevantSharePointListName>')/items(<VersionsRelevantItemID>)/versions
have fun