Forum Discussion
OData error with Dynamics CRM Online
I'm trying to connect PowerBI desktop to an online Dynamics CRM instance. However I'm getting the following error:
DataFormat.Error: OData: 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.
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.
31 Replies
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?
I have also tried using the trailing '/', with no success. I am not using a browser to connect, but the actual desktop application.
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.
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: The given URL neither points to an OData service or a feed"
I think issue is with crm5.
Please suggest.
Regards,
Deepak
It looks like your URL might have an extra terminating period -- or is that only in the transcribed version?
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.
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
This solved my issue as well. Thank you.
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?
