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 Anonymous
I had to add my SharePoint URL to this list of trusted sites in my Internet Options to overcome that error-message.