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

Re: OData error with Dynamics CRM Online

No matter what we try, remove credentials, different syntax, copy from our CRM online, everything we can technically effect and we get this error over and over. Does anybody have any reasons they can think of why this is not working or can help resolve it?  

 

Details: "OData: The given URL neither points to an OData service or a feed:

Marcel Occasional Visitor
Occasional Visitor

Re: OData error with Dynamics CRM Online

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

hbhickman Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

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: The given URL neither points to an OData service or a feed: 'https://login.microsoftonline.com/c7b...........b-ad15da2087df/wsfed

ChrisOlsen Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

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?

ekaratkiewicz Occasional Visitor
Occasional Visitor

Re: OData error with Dynamics CRM Online

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

ChrisOlsen Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

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

ChrisOlsen Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

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

RobJo Regular Visitor
Regular Visitor

Re: OData error with Dynamics CRM Online

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.

Highlighted
RobJo Regular Visitor
Regular Visitor

Re: OData error with Dynamics CRM Online

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

 

ginnibobinni Frequent Visitor
Frequent Visitor

Re: OData error with Dynamics CRM Online

This worked for me. We run Dynamics CRM online in the government cloud, BTW.