OData error with Dynamics CRM Online

[iFrech]

I'm trying to connect PowerBI desktop to an online Dynamics CRM instance. However I'm getting the following error: 

DataFormat.Error: OData&colon; The given URL neither points to an OData service or a feed: 'https://<xyz>.crm.dynamics.com/XRMServices/2011/OrganizationData.svc'.
Details:
https://<xyz>.crm.dynamics.com/XRMServices/2011/OrganizationData.svc

where <xyz> is the actual tenant. I have previously been able to use the Get Data function from Dynamics CRM online with another tenant and been able to retrieve the data. However, this specific URL gives me trouble. Could it be some sort of configuration on the CRM environment?

Also: I never get prompted for user/password information.

[Sky]

I cleared the permission and the connection to CRM started working, but the same issue occured again! I'm wondering what actually is triggering the issue and how can be prevented?

[RobJo]

Hi,

I have the same issue.

And tried the solution. Deleted connections. Restarted Power BI. Tried Instance WEB API with organisational credentials.
Succeeded to sign-in. After connect a error: Details: "The field 'regardingobjectid_cdi_unsubscribe' already exists in the record."
(Microsoft Dynamics® CRM Online 2016 Update(8.0.1.90) (DB 8.0.1.88)).

Can anyone help me please?

Rob.

[RobJo]

I found a solution.
In CRM properties this is the URL:

https:// <tenant> .crm4.dynamics.com/XRMServices/2011/Organization.svc

In Power BI, get data, CRM Online the example of the URL is:
https:// <tenant> .crm4.dynamics.com/XRMServices/2011/OrganizationData.svc

In stead of copy/paste the URL i changed the URL and added "Data" tot "Organization.svc".
Now i could register and connected to the CRM Online.

Rob

[zylawys]

RobJo... you are a life saver.

[hvoncannon]

This solved my issue as well. Thank you. 

[deepakk3010]

Hi,

I am trying to connect with MS CRM Online but getting below error:

Unable to connect:

We encoutered an error while trying to connec to "https://<orgname>crm5.dynamics.com/XRMServices/2011/OrganizationData.svc."

Detail:"OData&colon; The given URL neither points to an OData service or a feed"

I think issue is with crm5.

Please suggest.

Regards,

Deepak

[curth]

It looks like your URL might have an extra terminating period -- or is that only in the transcribed version?

[Greg_Deckler]

Try a trailing / on your URL. Are you using the OData connection or the Microsoft CRM connection? I have tried both and both work. You should get prompted to sign-in, you might try a private browser session. I have done this in Edge and IE 11, are you using one of those browsers?

[iFrech]

I have also tried using the trailing '/', with no success. I am not using a browser to connect, but the actual desktop application.

[TPalmer · Accepted solution]

If you weren't prompted for a username/password it's possible you already had credentials stored. You could try deleting your credentials and connecting again, at which point you should be prompted to login and can choose Organizational Account. Sometimes that error ("neither OData service or feed") can be caused by connecting with the wrong credentails - the feed will redirect you to a login page instead of connecting to the feed.

[Natalija]

Sorry, but where  

>You could try deleting your credentials and connecting again

?

I can't find...

[spenzchiu]

I'm having the same issues. I cannot refresh my CRM Online data using oData feed. How can I delete the credentials?

[Sergeik]

Just another way to expose Dynamics CRM data as Odata endpoint is to use this connector.

[dtejeda]

---

@spenzchiu wrote:

I'm having the same issues. I cannot refresh my CRM Online data using oData feed. How can I delete the credentials?

---

To remove the credentials, go to File in Power BI and select Options and Settings and select the Data Source Settings Option. You will see the Data Sources you are using in your file and there you can Clear Permissions from one or all of them.

Hope this helps!

[Marcel]

In Power BI Desktop - choose File - Options and Settings - Data Source Settings - Select a Datasource and click Edit - Delete credentials.

[hbhickman]

Still didn't work. Keeps coming back with the same service error error. This is a partner demo site with one use that works and connects with everything else. Have tried almost every combination and still won't connect. Worse thing is we could really use this when pitching larger organizations

Details: "OData&colon; The given URL neither points to an OData service or a feed: 'https://login.microsoftonline.com/c7b...........b-ad15da2087df/wsfed

[ChrisOlsen]

I am getting exactly the same issue with CRM 2016, just cannot get it t work, think i have tried everything proposed.

Is this a CRM version issue?

[ekaratkiewicz]

Same issue, nothing is resolving- on Office 2016. Any luck?

[ChrisOlsen]

None, I tried again this morning with a CRM 2015 site but that did not work either.

[ChrisOlsen]

I found the solution to this for CRM 2016 Online.

I did the following:

In CRM went to: Settings/Customizations/Developer Resources and copied the 'Instance Web API' URL.

This is in the form of https://organization.api.crm[x].dynamics.com/api/data/v8.0/

In PowerBI I wen to 'Get Data Source' and selected 'Microsoft CRM' and pasted in the 'Instance Web API' from MS CRM.

I then selected Organizational Account and clicked 'Sign In'

The Office 365 log-on screen was then presented and I entered my Office 365 credentials.

I clicked 'Connect', magic happened and I got a connection.

Chris