Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
9 years ago

MS Dynamics Nave 2016 data connection

What is the work around the bug preventing Window Authencation to MS Dynamics NAV with BI ODATA connection.   I am new to NAV and not sure then best approach to setup the Web Service.   K
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi kfschaefer,

 

>>What is the work around the bug preventing Window Authencation to MS Dynamics NAV with BI ODATA connection.

There are two type of dynamic nav datasource. Dynamic nav online and onpremise.

 

If you use the dynamic nav online, power bi will use the "Connect directly" mode to link the source, it only support sign in with the OAuth2.

If you use the dynamic nav on-premise datasource, you need a gateway to connect the source, then you can try to sign in with windows authencation.

 

Regards,

Xiaoxin Sheng

 

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
9 years ago

"If you use the dynamic nav on-premise datasource, you need a gateway to connect the source, then you can try to sign in with windows authencation."

 

Please explain in more detail.

 

K

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi kfschaefer,

     

    >>"If you use the dynamic nav on-premise datasource, you need a gateway to connect the source, then you can try to sign in with windows authencation."

     

    1. Use Odata to get data from dynamic nav on-premise.
    2. Publish report to service, open the the "Manage Gateways" menu.
    3. Add a odata datasource to on-premise gateway, choose window authentication method.

     

    Regards.,

    Xiaoxin Sheng