Power BI desktop windows authentication + Nav 2016

[mnitguy]

Trying to get power bi to connect via odata to a nav 2016 database and keep getting "user not authorized" if windows authentication is selected. If we switch the nav service tier to navuserpassword type, it works with Power BI/Basic authentication.

Any ideas on whats going on?  We can connect to the odata feed through excel and connect to the port via webpage and view xml just not with Power BI?

[mnitguy]

Trying to get power bi to connect via odata to a nav 2016 database and keep getting "user not authorized" if windows authentication is selected. If we switch the nav service tier to navuserpassword type, it works with Power BI/Basic authentication.

Any ideas on whats going on?  We can connect to the odata feed through excel and connect to the port via webpage and view xml just not with Power BI?

[v-sihou-msft]

@mnitguy

For Dynamic Nav content pack, only Basic Authentication is currently supported in Power BI. For more details, please see: Microsoft Dynamics NAV content pack for Power BI

Regards,

[JOHNS]

Hi,

Is there any plan to enable windows authentication?

This, in my experience, is the primary form of authentication used.

Thanks,

J

[v-sihou-msft]

@JOHNS

Unfortunately, it's still not supported. Please submit a feature request on Idea

Regards,

[JOHNS]

Hi,

Is there any plan to enable windows authentication?

This, in my experience, is the primary form of authentication used.

Thanks,

J