web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Not able to Create Odata connection in Excel with Dynamics CRM

(0) ShareShare
ReportReport
Posted on by 522

Hello,

In order to prepare reports , I am not able to connect Excel with Dynamics crm using Odata feed.My Odata Connection URL looks like this  https://kspljune.api.crm.dynamics.com/api/data/v9.2/

Will it bring real time data automatically after that or any other component needs to be installed?

Is there any prerequisite for installing any extension to use Powerview, Powermap, Powerpivot using excel?

I have the same question (0)
  • Suggested answer
    Kenneth Ariel Chaves Herrera Profile Picture
    on at

    Hi megha18 I hope you are doing good.

    What probably is happening is that you are getting that error because that functionality has been deprecated at some point. Here the process to connect to Dynamics 365 from Excel:

    Connect to Dynamics CRM 365 Online from Excel [Reporting] - Microsoft Dynamics CRM Community

    I would recommend you follow it and then it should be working.

    Here are some interesting things you can develop once everything is working:

    (+) Playing With CRM Data In Excel - Microsoft Dynamics CRM Community

    If this answers your question, please check it as verified to help others find useful information.

    Welcome to this amazing community.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans