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.
Solved! Go to 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.
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?
Proud to be a Datanaut!
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.
Thank you. This totally worked.
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?
Thanks for the help from this solution. Saved me from a major headache.
Sorry, but where
>You could try deleting your credentials and connecting again
?
I can't find...
I'm having the same issues. I cannot refresh my CRM Online data using oData feed. How can I delete the credentials?
User | Count |
---|---|
21 | |
20 | |
17 | |
16 | |
11 |