Forum Discussion

iFrech's avatar
iFrech
New Member
11 years ago
Solved

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: The given URL neither points to an OData service...
  • TPalmer's avatar
    TPalmer
    11 years ago

    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.

ChrisOlsen's avatar
ChrisOlsen
Advocate I
10 years ago

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

ginnibobinni's avatar
ginnibobinni
Regular Visitor
10 years ago

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