The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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! 😉
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
42 | |
23 | |
22 | |
18 |