Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm facing some problems when I try to add a data source from SQL server. This is what I get :
Activity ID: | 9854c13b-2074-4b78-b0a1-4467bb634505 |
Request ID: | 85ee802b-6523-ba63-2a13-2a2b1f63c6ce |
Cluster URI: | https://wabi-france-central-a-primary-redirect.analysis.windows.net/ |
Status code: | 400 |
Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
Time: | Mon Dec 06 2021 11:50:32 GMT+0100 (heure normale d’Europe centrale) |
Service version: | 13.0.17186.43 |
Client version: | 2111.3.08807-train |
my_gateway: | Invalid connection credentials. |
Underlying error code: | -2146232060 |
Underlying error message: | Login failed for user 'my_adress@adress.com'. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2146232060 |
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: | 18456 |
The adress I used to add the data source is the one I use to connect to SQL server. But, I use a different one to connect to PowerBi. I'ts maybe the problem, but I'm not sure.
Also, I used the basic authentification method to do it.
I tried the the windows authentification method, but I also got an error which is : "The on-premises data gateway's service account failed to impersonate the user."
Have you any ideas to solve this problem ?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See this from the docuement:
If there isn't a Delegation tab on the Properties dialog box, you can manually create an SPN on the account to enable it. Use the setspn tool that comes with Windows (you need domain admin rights to create the SPN).
So if you are not the domain admin, perhaps you have no access to create the SPN.
Best Regards,
Community Support Team _ Yingjie Li