locked
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?

    Thanks,

    Erik

    Monday, September 13, 2010 1:06 PM

Answers

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

    John

    Monday, September 13, 2010 6:44 PM