Sharepoint.Contents generates 'key didn't match any rows in the table' but only for some users

[martinslavoie]

I have created queries to read off excel sheets located on SharePoint site (I have full control access). Those work perfectly when using my account. As soon as a colleague (who also has been granted Full Control rights to the entire site) tries to run the query it fails saying 'key didn't match any rows in the table'. The Document directory cannot not even be read as the query fails on this navigation step. 

I have had the user(s) remove all Global Permissions and then reconnect with using their Organizational accounts but that did not work either.

I have tried both .Contents and .Files methods and both fail. It certainly looks like an access issue but even my Sharepoint site admin could not find any issues with my colleagues accounts' permissions.

[v-alq-msft]

Hi, @martinslavoie 

I wonder if you have tried using the 'SharePoint Folder' connector and inputing in the root of the site. For further information, you may refer to the similar thread to see if it helpss.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

I would have your SharePoint admin look at the permissions on the document library and compare that to a new site with no custom permissions set. I've seen issues where SP security/permissions caused weird issues. SharePoint.Files works, SharePoint.Contents fails. Importing a single file works, doing a combine operation fails, etc. Just weird issues that work totally fine in the browser but in Power Query these issues manifest themselves.