Search code examples
excelasp.net-web-apiodatalinqpadpowerquery

OData v4 via Excel - The required attribute Relationship is missing

I'm trying to test a new OData v4 web API I'm building with Excel and LinqPad but I'm getting the following error:

The required attribute Relationship is missing

The API seems correctly built, but "Relationship" never turns up in metadata, no matter how I structure the model.

What's going on? I'm sensing that v3 and 4 are not compatible.

Solution

  • PowerQuery does not yet support OData v4. You can harrass the development team here: :)

    https://social.technet.microsoft.com/Forums/en-US/2169958f-9e2a-4fc2-a844-c0dce4c17a19/support-of-odata-v40?forum=powerquery

    LinqPad's driver is clearly v3, but a search on linqpad.net reveals no mention of v4.