Forum Discussion
cluster gateway odata dynamics CRM
Hi everyone,
One more problem,
I got many cluster gateway...one of those is a odata connection with DynamicsCRM
I found this post but I didn't find an issue :
https://community.powerbi.com/t5/Service/Power-BI-OData-CRM-Authentication-Issue/m-p/349662#M39309
My report got several connections (with sql server and dynamics CRM) so I set the clusters.
My URL : https://XXXXX.api.crm4.dynamics.com/api/data/v9.0
Auth : windows (but I don't agree with that cause this is a pro account connexion, neither a db connexion or windows connexion - I don't have the option "pro account)
When I do the connexting test :
Impossible de se connecter Nous avons rencontré une erreur lors de la tentative de connexion à . Détails :
| ID d'activité: | 3b8bede0-852b-4f33-aec3-d5677c45de36 |
| ID de demande: | 14538ca5-2d4f-a40e-57a9-acd0a92f2046 |
| URI du cluster: | https://wabi-west-europe-redirect.analysis.windows.net |
| Code d'état: | 400 |
| Code d'erreur: | DMTS_UpdateClusterDatasourceCredentialsErrorCode |
| Heure: | Thu Sep 12 2019 09:14:17 GMT+0200 (heure d’été d’Europe centrale) |
| Version: | 13.0.10668.164 |
| Passerelle PBI - Allizé: | Informations d'identification de connexion non valides. |
Code d'erreur sous-jacent: | -2147467259 |
| Message d'erreur sous-jacent: | Les informations d'identification fournies pour la source OData ne sont pas valides. (Emplacement de la source : https://cfp.api.crm4.dynamics.com/api/data/v9.0) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | OData |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | https://cfp.api.crm4.dynamics.com/api/data/v9.0 |
| Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
| Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"OData","path":"https://cfp.api.crm4.dynamics.com/api/data/v9.0"}] |
| Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
And I can't schedule a refresh...
I don't know if I'm clear, let me know if I'm not!
Thank you for all,
Baptiste