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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Can I use PowerPivot i...
Microsoft Dynamics CRM (Archived)

Can I use PowerPivot in Excel 2010 with Dynamics CRM Online?

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

Quick question, I am trying to use PowerPivot in Excel 2010 to connect my organisation's Dynamics CRM online account...

When I try and connect using the Organization Data Service Protocol: OData (REST) -

https://[Org Name].crm4.dynamics.com/XRMServices/2011/OrganizationData.svc/  

I get the following error:

"Cannot connect to the specified feed. Verify the connection and try again. Reason: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method."


Am I mistaken in thinking that I can connect CRM Online to Excel 2010....or am I just doing something wrong?

Thanks,

Alex

*This post is locked for comments

I have the same question (0)
  • Michael Hammons Profile Picture
    Michael Hammons on at

    Hi Alex,

    Currently, PowerPivot does NOT support connecting directly to Dynamics CRM Online.

    Good news though, Power Query DOES support connecting Dynamics CRM Online and should work with Excel 2010. Once you have connected to CRM Online and brought in the data into Excel, you can then build your PowerPivots.

    www.microsoft.com/.../details.aspx

    Mike

  • Suggested answer
    Josh Thompson Profile Picture
    Josh Thompson 1,115 on at

    I know you can do it with Excel 2013 and PowerQuery.

    Here is a step-by-step:  niiranen.eu/.../connecting-crm-online-odata-feed-excel-2013-power-query

    This will probably work with 2010 as well, just as Michael stated.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
AS-17030037-0 Profile Picture

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans