Expression Error.: The key didn't match any rows in the table

[Gstaih]

Good Day Community! 

Would love some help understanding the below message and fixing it if possible!  

 and here it is in the advanced query mode: 

Please note,

1- Data source is from sharepoint.

2- The user, who created the excel files template in sharepoint and power Bi report, their account was removed from the group. 

3- After said user was removed, we received the error message above. 

Would appreciate any help, 

Kind regards. 

[Gstaih]

@Greg_Deckler thanks mate, changed the credential permissions, and now its working all fine. 

[Greg_Deckler]

@Gstaih Correct, what the error is saying is that it doesn't find anything in that SharePoint list and this would be because they don't have access so no documents or "rows" are returned.

[Gstaih]

Hi Greg @Greg_Deckler 

Thanks for taking time to answer, so what would you suggest as a solution?

[Greg_Deckler · Accepted solution]

@Gstaih Well, either add the user back to the SharePoint list or change the credentials on the data source so that it uses a user with permissions. In the Desktop you can do this via File | Options and settings | Data source settings.