This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I am getting the following error code:
Error code: DMTS_DatasourceHasNoCredentialError
Connection error: Connection has no credentials
I have an on-premises SQL Gate Way that I am unable to add credentials.
The connection type is analysis service through a data cube which is also on premise.
I have gone into the gateway settings and the only authentication option is “Windows without impersonation”.
Even after selecting this option, I am unable to save the settings. I will click save but nothing will happen.
Is there another way to enter credentials or am I missing a step somewhere else.
Thanks.
Hi @VQL95 ,
First, ensure that you’re using a supported version of the on-premises data gateway.
Check whether the user of the SQL statement is valid,Grant permissions to users in SQL statements
You can see the Microsoft's official link:
Troubleshoot the on-premises data gateway | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 7 | |
| 7 | |
| 6 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 21 | |
| 21 | |
| 19 |