Forum Discussion
The key didn't match any rows in the table error message. SQL server in Power BI Service.
I have a gateway which refreshed my datasources. They worked fine but now suddenly it gives an error "The key didn't match any rows in the table error message". I can update everything just fine in t...
So after troubleshooting, I discovered that the authentication method for the gateway for that data source was using 'Windows' instead of 'Basic'. I updated all of my credentials and it works now!
Hi Anonymous ,
I will provide several solutions and you could try and check if they work.
1. Check the credential. Confirm it is the same credential used in your desktop.
2. Update to the latest version of gateway.
3. Re-configure your gateway.
If these solutions are useless, you could create a support ticket for further help.
So after troubleshooting, I discovered that the authentication method for the gateway for that data source was using 'Windows' instead of 'Basic'. I updated all of my credentials and it works now!