Forum Discussion
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 persmission is set to Read items created by user only:
As owner, I can see all items in that SPO list withotu issues. But when I try to access PowerQuery, it implies that list is empty (if I have no items created there myself) or only shows me my own items:
In the past this worked fine , since I am owner / site collection adminn in SPO, it was pulling all items from list, now stopped. What can caused this issue? Any change from PBI/PowerQuery side? Any way to fix this?
7 Replies
Please elaborate on the "stopped working" part. Did you get an error message?
Before same query returned all items from SPO list, now it doesn't see any apart from ones created by myself.
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.
I'm having the exact same issue as you've described. It was working without any issues and changed without warning. Did you figure out a solution/fix to this?
