[OLINGO-1264] Wrong result of navigation entities in PowerBI and Excel

• Type: Question
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Component/s: odata4-server
• Assignee: Unassigned
• Reporter: sana khiari
• Created: 22/May/18 12:53
• Updated: 22/May/18 13:05

Description

When I use this url (Products/categories example tutorial) to upload an odata feed in powerBi :

http://localhost:8080/DemoService/DemoService.svc/Categories(1)/Products

I don't get the json result as postman and all browsers display, instead I get the same result of this url:

http://localhost:8080/DemoService/DemoService.svc/Products

I tried with changing the relative url in serviceRoot(absoluteUrl), changing odata.metadata=full instead of minimal, downgrading to olingo 4.0.0 (since I currently use 4.4.0).

When debugging the application, I noticed that the returned result is correct but then I get another one in PowerBI.

I guess navigation links aren't detected by PowerBI or there is some missing configuration in the metadata file.

Does anyone have a solution to suggest please?