Forum Discussion
PowerQuery with SPO list data source showing only my own items
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.
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).
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 .