Forum Discussion

marceloerthal's avatar
marceloerthal
New Member
9 years ago

Dynamics Nav 2015 Odata authentication problem

Hi,   I have a Odata connection that works perfect with Excel. Here´s the connection string:   Data Source=http://nav.impeto.local:9048/IMP-PRD-2015/OData/Company('SERVICOS')/Dimensoes; Namespac...
Need Help
ea25's avatar
ea25
Frequent Visitor
9 years ago

 

I had a similar issue to the one reported here. 

 

In my case when calling the OData feed URL, I used the IP Address of the NAV server instead of the machine name. This worked straight away.

 

This root cause was not not the lack of a DNS server on our enviroment as I did manage to get the JSON file when I pasted the OData URL (with the machine name) into the browser. For some odd reason which I still can't figure out, PowerBI was returning "The User was not authorised" error in PowerBI when referring the machine name.

 

Hope this helps.