Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Cannot access Odata fe...

Cannot access Odata feed in Excel for CRM online

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

As subject line really. I need to access the "Odata" feed in excel, but for some reason it gives me this error every time regardless of the log-in details used. My access is full admin/customisation.

76480.Capture.PNG

I am using the correct URL as far as I am aware:

0525.Capture2.PNG

Any ideas?

Many thanks

David

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

TheMarkChristie 10,328 on at

Like (0)

Report

RE: Cannot access Odata feed in Excel for CRM online

Hi David

My Guide Here might help you with the connection

community.dynamics.com/.../power-bi-amp-crm-2016-update-1
Verified answer

Drew Poggemann 9,079 on at

Like (0)

Report

RE: Cannot access Odata feed in Excel for CRM online

Hi David, for an OData feed for Dynamics CRM use the following (which is the new OData connection URL):

https://[environment url].api.crm.dynamics.com/api/data/v8.1/

Thanks,