Forum Discussion

vbvbvb's avatar
vbvbvb
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

PowerQuery with SPO list data source showing only my own items

Hi all,   I have a weird issue with query using only SPO list source. Before it was working fine, but suddently without any changes stopped working. I have a SPO list where there's list item-level ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please elaborate on the "stopped working"  part.  Did you get an error message?

  • vbvbvb's avatar
    vbvbvb
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Before same query returned all items from SPO list, now it doesn't see any apart from ones created by myself.

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      You can use Query Diagnostics to see which exact API call is made against your SharePoint list. I assume you have already checked that you use the right login for authentication.

      • vbvbvb's avatar
        vbvbvb
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        Yes , I did check all possible permissions etc. It seems that something was changed in the backend which now doesn't take admin rights in SPO to account anymore (which allow admin/owners  to see all list items from all users).