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,
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
Solved! Go to Solution.
@Anonymous I believe the Odata and CRM connections require the OAuth connection type, not windows.
@Anonymous I believe the Odata and CRM connections require the OAuth connection type, not windows.
Hey, thank you
Ok, I agree
How can I do it? What shall I change in my cluster settings?
@Anonymous It should be in the drop down selector when you authenticate on the dataset in the Service.
Sorry,
that's finally good!
Thank you!
I had to delete the cluster before.
The refresh was working! 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |