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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
TPalmer
Microsoft Employee
Microsoft Employee

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

Thanks,  it worked for me

Greetings,

 

The solutions is still valid for Dynamics 365, in April of 2019.

 

Thank you.

Thanks Chris the API URL worked

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

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&colon; The given URL neither points to an OData service or a feed:

 

CaptureCRMPBI.PNGI too have problems with connecting to Dynamics CRM.  I tried logging in with Organizational Account and got this error.  Can anyone help?

 Hello Lucy, 

 

I was having the same issue you seem to be having. Check the Organization Service URL that you copied from your CRM Customizations Page, eg: 'https://<org>.crm.dynamic.com/XRMServices/2011/OrganizationData.svc'.

 

The link that was in my CRM left out the word 'Data' after Organization. I simply typed in 'Data' back in and it worked for me. Hope this helps. 

 

hvoncannon you are a star!

 

I have been trying for months to get connected to CRM and who would have known that the word "Data" was all it needed.

Thanks a million.

Awesome! Glad I could help. 

 

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

Thank you. This totally worked.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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