Issues connecting to Dynamics CRM Online

[PeterL]

I tried to connect to Dynamics CRM Online using the content pack in the library. After I clicked Connect, I entered the service URL. But the Next button is not enabled.

Is there anything special I need to do to connect to Dynamics CRM Online?

Thanks,

Peter.

[Greg_Deckler · Accepted solution]

The format of your URL needs to be:

https://tenant.crm.dynamics.com/XRMServices/2011/OrganizationData.svc

No trailing backslash and replace "tenant" with your tenant. I have an article on it here:

https://www.linkedin.com/pulse/building-ultimate-microsoft-crm-dashboard-under-hour-greg-deckler?trk...

I think removing the trailing backslash is new...

[vasu20in]

I tried different ways but unable to conclude which way is the correct way to connect dynamics crm from Powerbi. Instructions which exist on PowerBI windows and Online are confusing. Currently i am connnecting using the below URLs.

PowerBI online        :               https://tenant.crm.dynamics.com    (CRM URL)

PowerBI Desktop               :               https://tenant.crm.dynamics.com/api/data/v8.1 (CRM Service root url)

Kicker is, when i am trying to connect to dynamcis crm online through PowerBI online I am using above URLs but example which is showed in PowerBI desktop at the time of connecting CRM online is different. It says to provide the organisation URL which ends like this https://tenant.crm.dynamics.com/XRMServices/2011/Organization.svc but it never got succeeded when i used Organisation URLl. I am able to connect using above service root url rather than the Organisation Service URL.

Same case with PowerBI online it never used the Organisation URL but infact i am just providing the direct CRM URL.

Can any one confirm how are you connnecting to CRM online from PowerBI windows?