Problem connection with Dynamics365 (crm)

[Anonymous]

Hi everyone,

I got a problem to connect PBID with my db Dynamics365 (CRM).

I choose "Dynamics365 (online)" (that it is!)...I write the URL "https://...crm4.dynamics.com" and check my admin id/password. The id is the email.

I check in the id/pass in each possibility. Each case send me back an error.

Sometimes, I got an error about the id auth, sometimes I gotthis message "Détails : « OData : l'URL fournie ne pointe ni sur un service OData ni sur un flux : « https://login.microsoftonline.com/e......."

I find this out on the forum (problem with compatibility) :

https://community.powerbi.com/t5/Integrations-with-Files-and/Error-while-retrieving-data-from-Dynami...

What do you think about?

Thank you,

Baptiste

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, it could work on my side:

You could get the url refer to below way:

Settings -> Customizations -> Developer Resources -> URL

Use the Power BI Desktop to connect the url with organizational data:

Regards,

Daniel He

[Anonymous]

Sorry, I used URL connexion...

I had to choose "Dynamics 365" connexion. The URL I get with your help is working!

Thank you!

[Anonymous]

Hi, thank you for your answer.

Your issue gimme 2 Tables ("Query1" and "Query2") with 2 columns "Name" and "Value".

On a Table, each query notify :

Name                       Value

@odata.context       https://xxxxxxxxxxxx.dynamics.com/........../$metadata

value                        [List]