Forum Discussion
Key Expression Error: The key didn't match any rows in the table
Anonymous
Based on my test, the refresh from desktop and gateway use the same queries. In your previous reply, you say "The credentials I have entered has access to all data in our Oracle Database", Can you confirm it is the same credential used in your desktop where, as you state, the refresh works fine. If not the same, login Oracle with that credential and try to running the queries captured from Power BI gateway.
Microsoft EmployeeAnonymous
Based on my test, the refresh from desktop and gateway use the same queries. In your previous reply, you say "The credentials I have entered has access to all data in our Oracle Database", Can you confirm it is the same credential used in your desktop where, as you state, the refresh works fine. If not the same, login Oracle with that credential and try to running the queries captured from Power BI gateway.
You were right it all came back to the credentials I was using to login. Sorry I am interning and trying to show this to my bosses and I guess what I was logging in with didn't have the right credentials. Thank you for all the help!