Forum Discussion
SharePoint.Files() works but SharePoint.Contents() won't authenticate
Recently migrated hundreds of Windows shares to SharePoint Online. This forced us to modify any processes that used Power Query to read data from Windows to now read data from SharePoint. Most of the...
I have exactly the same issue here.
But... a few users in my organization are able to use SharePoint.Contents without any problems.
Other users are not able to use SharePoint.Contents due to the authetication problem you mentioned.
I still could not determine why this works with a few users. Different Sharepoint priviledges?
EDIT: Yes, I confirmed that different Sharepoint priviledges makes the whole difference.
I asked to change temporarily my priviledge to "site owner" and now SharePoint.Contents works flawlessly.
Hello! I'm having the exact same issue. Do you get past from the Sharepoint Owner limitation?