cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
iFrech Frequent Visitor
Frequent Visitor

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&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.

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team TPalmer
Power BI Team

Re: OData error with Dynamics CRM Online

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.

View solution in original post

31 REPLIES 31
Super User
Super User

Re: OData error with Dynamics CRM Online

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 book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

iFrech Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

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

Power BI Team TPalmer
Power BI Team

Re: OData error with Dynamics CRM Online

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.

View solution in original post

iFrech Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

Thank you. This totally worked.

deepakk3010 New Member
New Member

Re: OData error with Dynamics CRM Online

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

Power BI Team curth
Power BI Team

Re: OData error with Dynamics CRM Online

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

MarkAVT Occasional Visitor
Occasional Visitor

Re: OData error with Dynamics CRM Online

 

Thanks for the help from this solution. Saved me from a major headache.

Natalija Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

Sorry, but where  

>You could try deleting your credentials and connecting again

?

 

I can't find...

spenzchiu New Member
New Member

Re: OData error with Dynamics CRM Online

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 238 members 2,054 guests
Please welcome our newest community members: