When will PowerPivot support automatic relationships in OData?

Question

I've read that PowerPivot doesn't support the automatic creation of entity relationships when consuming OData feeds.

Can anyone confirm this and is anyone aware of the PowerPivot OData roadmap? Is it coming?

Thanks, Mike

Answer 1

Yes that is correct. Relationships are lost when imported into PowerPivot.

This is why best practice is to expose ForeignKey properties from your Data Services, that way you can rebuild the relationship in PowerPivot.

In terms of when / if PowerPivot will add better support for relationships - we ( I am a Program Manager ) on the OData team hope so, but there isn't a firm commitment or timeframe yet.