Gateway refresh error 'The key didn't match any rows in the table.'

[IanCockcroft]

Hi guys,

a gateway refresh is failing with the error

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

The source is a SQL database

all the searches for    the error and solutions are for excel.

Any idea idea why?

[v-chuncz-msft]

@IanCockcroft 

Go through each step of the query in Query Editor to troubleshoot this problem.

https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor

[IanCockcroft · Accepted solution]

AAAAAAAAAAAHHHHHHHHHHHHH

Service account running the gateway DID NOT have read access

[IanCockcroft]

Thanks for taking a look.

The thing is, in the desktop it doesnt throw the error.

Only on gatewy refresh.

hence, i cant see where the error is being thrown