cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Highlighted
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
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)