Forum Discussion
ERROR 400 - SQL CREDENTIALS [POWER BI SERVICES]
I've ben trying to edit the credentials, but every time a try this error occours (ERROR: 400). the credentials works fine on PBI Desktop, the datasource is a SQL query and i'm using a personal gateway.
I literally tryed every single combination of authentication and none of the options worked. Does anyone know how to fix it?
Thanks
Hi, jessicabonicenh
Is your local gateway working properly? Have you tried standard on-premises data gateway?
Please refer to the following process to reconfigure the gateway.
Manage your data source - SQL Server
Please recheck your Server Name and Database Name. If you use Windows authentication, you also need to recheck your user name format(domian\user).
Update:
Please check if solution in below thread could help.
Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400
Best Regards,
Community Support Team _ Eason
2 Replies
- lbendlin
Super User
check your connection details for typos, extra spaces etc.
- v-easonf-msft
Community Support
Hi, jessicabonicenh
Is your local gateway working properly? Have you tried standard on-premises data gateway?
Please refer to the following process to reconfigure the gateway.
Manage your data source - SQL Server
Please recheck your Server Name and Database Name. If you use Windows authentication, you also need to recheck your user name format(domian\user).
Update:
Please check if solution in below thread could help.
Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400
Best Regards,
Community Support Team _ Eason
