PowerQuery with SPO list data source showing only my own items

[vbvbvb]

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?

[jacksobp]

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?

[lbendlin]

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

[vbvbvb]

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

[lbendlin]

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]

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).

[lbendlin]

Sounds like it.  If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[vbvbvb]

Well, I guess it would have to go this way, would try to trace down right folks internally who can get in touch with right devs.