MS Dynamics CRM data connection in Excel 2016 failed

Question

I am getting error establishing a data connection in excel to import MS Dynamics report. Here what I have followed so far:

1. Went to Data tab >> New Query >> From Online services >> From Dynamics CRM online.
2. A pop up comes up saying Enter URL. Refer to Image below>

I put the URL I got from developer resource in MS CRM that exactly looks like this format

3. This is the url I am using (cannot reveal org name)-

   https://orgname.api.crm.dynamics.com/XRMServices/2011/Organization.svc

4. When I click next, I get this error -

   OData: The given URL neither points to an OData service or a feed: 'https://orgname.api.crm.dynamics.com/XRMServices/2011/Organization.svc'.

Why I am getting this error and what is the possible resolution?

Answer 1

You have to use OrganizationData.svc.

The URL will look like: https://orgname.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/

Note the trailing slash / at the end of URL.

Refer this

Settings – Customizations – Developer Resources menu