Forum Discussion

bpearce's avatar
bpearce
Advocate I
4 years ago

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...
Need Help
bpearce's avatar
bpearce
Advocate I
4 years ago

Anonymous - I appreciate your comments. I have tried Table.Buffer() is some ill-performing queries but with limited success. I have not tried Binary.Buffer() but will give it a look. For the original question though it is not much help as I can't get past the SharePoint.Contents() function as it errors out on authentication.

 

FWIW - Since my original post I have tried SharePoint.Contents ("mysite",APIVersion = 14) and got past the authentication issue, but general performance is on the same order as SharePoint.Files(). 

 

  • andyoliver's avatar
    andyoliver
    Frequent Visitor
    2 years ago

    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.

    • RafaelReis's avatar
      RafaelReis
      Regular Visitor
      2 years ago

      Hello! I'm having the exact same issue. Do you get past from the Sharepoint Owner limitation?