PowerPivot & Microsoft Dynamics CRM 2011 – Part 1

Wednesday, January 9, 2013

PowerPivot for Excel 2010 is not a new feature, but only recently I have became aware to its capabilities in conjunction with Microsoft Dynamics CRM 2011. One of the data sources PowerPivot can extract data from, is OData Services. As Microsoft Dynamics CRM 2011 exposes an OData service (OrganizationData.svc), PowerPivot can be harnessed to analyze MSCRM2011 business entities data and solves some basic problems by the way: Lack of Outer Join support in Advanced Find queries Dynamic PivotTable/Table performance issues One entity limit in Dynamic...