cluster gateway odata dynamics CRM

[Anonymous]

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

[Seth_C_Bauer · Accepted solution]

@Anonymous I believe the Odata and CRM connections require the OAuth connection type, not windows.

[Anonymous]

Hey, thank you

Ok, I agree

How can I do it? What shall I change in my cluster settings?

[Seth_C_Bauer]

@Anonymous It should be in the drop down selector when you authenticate on the dataset in the Service. 

[Anonymous]

Sorry,

that's finally good!

Thank you!

I had to delete the cluster before.

The refresh was working! 😉