Does PowerPivot for Excel support importing OData service metadata? RRS feed

  • Question

  • Hi,

    An OData feed supports getting information about the structure of the feed through the $metadata action, e.g.: http://services.odata.org/OData/OData.svc/$metadata

    When importing a feed, however, PowerPivot does not seem to use this data. You have to manually define all the relationships again in the PowerPivot window itself. Is there a way to get it to do this?



    Monday, September 13, 2010 1:06 PM


  • Hi Erik, unfortunately there is no automatic support for this in PowerPivot, you will need to manually define relationships.


    Monday, September 13, 2010 6:44 PM