Can't connect to NAV OData service - works everywhere else (Excel, other services)

[charleh]

Hi all, not sure if anyone has this issue but a while back we setup a Dynamics NAV OData feed which after some troubleshooting worked ok.

The feeds are refreshing every day and seem to be working, however, trying to add another feed that points to the same data source just results in a long long pause (5-10 minutes). Eventually the credentials box pops up but even with the correct credentials it fails to connect.

The api response in the browser depends on if we try and get to the endpoint via domain or IP.

It's hitting this URL: 

https://wabi-north-europe-redirect.analysis.windows.net/metadata/datamovement/gateways/72740/dataSou...

For IP we get

{"error":{"code":"UnknownError","pbi.error":{"code":"UnknownError"}}}

For domain we get a long long long wait then a 500 internal server error with this JSON response

{"Message":""}

Anyone got any ideas? We've had so much trouble with getting OData working with NAV and now it seems to have gone south again, getting frustrated now and thinking about offering other services...

This works fine in Excel, I can consume any of the OData sources from Excel with no issue.

[Anonymous]

Hi @charleh,

Perhaps you can take a look at below thread which has the same issue with how to connect to dynamic nav source on cloud.

How To Connect Power BI to Microsoft Dynamics NAV on the cloud

BTW, I test with odata on desktop without any issue.

Regards,

Xiaoxin Sheng

[charleh]

We are already connected to NAV twice (2016/2017) so there are no issues there, I think the issue is related to the technical problems everyone is having with OData sources and refreshes at the moment.

We just cannot make new connections (to the same data source) or refresh the existing one...