On premise GW problem - We couldn't parse OData response result....

[spehe]

I am trying to connect to our NAV2017 from PowerBI.com via an on-premise Gateway, using OdataV4.

Using the OdataV4 url in PowerBI Desktop or in a web browser will return correct data, but not when I use a Data Gateway. 

Any help will be deeply appreciated.

[spehe · Accepted solution]

I raised a ticket at Microsoft and together with them I found the problem.

- It turns out that to create a connection through a on-premise gateway you should use the root url, and not the complete url (e.g. https://nav.domain.xx:7048/NAV2017/ODataV4/Company('NAVcompany')/table will work in most other cases (PowerBI Desktop, in a web browser, et), but not in a on-premise gateway. Instead, it should be https://nav.domain.xx:7048/NAV2017/ODataV4).

[lbendlin]

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

[spehe]

Thanks, I'll do that.