Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
"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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.