MS Dynamics Nave 2016 data connection

[kfschaefer]

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

[v-shex-msft]

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]

"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

[v-shex-msft]

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