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.

  • rrosendahl's avatar
    rrosendahl
    Frequent Visitor
    9 years ago

    Hi EA25,

     

    Thx for the comment. Go to know that there is a way to work around this problem. The next time I will encounter this problem I'll try to use the IP instead, to see if it works for me too.

     

    Now we only have to figure out why it happends! ;)

    • ea25's avatar
      ea25
      Frequent Visitor
      9 years ago

      Indeed.

       

      It would be helpful if someone from MS can shed some light about this.