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
AlexChen's avatar
AlexChen
Microsoft Employee
9 years ago

Hi,

 

Are you using the latest powerbi desktop? If not, please update and try it again.

If the issue is still there, please follow the steps in articles below to see if it can be solved. And there is a similar case here.

 

https://blogs.msdn.microsoft.com/brushstrokes/2015/11/24/the-user-was-not-authorized-error-when-connecting-to-project-online/

https://blogs.msdn.microsoft.com/brushstrokes/2015/12/29/the-user-was-not-authorized-on-data-source-connection-at-power-bi-desktop/

 

Best Regards

Alex

 

  • marceloerthal's avatar
    marceloerthal
    New Member
    9 years ago

    Hi Alex,

     

    I am using the latest version of powerbi desktop.

     

    The similar case was solved by support?!? There´s no clear solution about it.

     

    unfortunally these articles, doesn´t apply to my problem:

     

    1) The data is never showed, unless I import the excel file from PB.

     

    2) It´s not a cashe problem

    • mnitguy's avatar
      mnitguy
      New Member
      9 years ago

      We're having the issue with Nav 2016, cannot connect with Power BI unless the service tier is set to navuserpassword.  Windows authentication does not work but from excel/using a web browser to access the port it works great.