Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
iFrech
New Member

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

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
Sky
Frequent Visitor

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
Helper I
Helper I

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

 

zylawys
Frequent Visitor

RobJo... you are a life saver.

This solved my issue as well. Thank you. 

deepakk3010
New Member

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

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

Greg_Deckler
Super User
Super User

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?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

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?

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


@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!

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

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

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?

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

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors