Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
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?
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,
Hi,
Is there any plan to enable windows authentication?
This, in my experience, is the primary form of authentication used.
Thanks,
J
Hi,
Is there any plan to enable windows authentication?
This, in my experience, is the primary form of authentication used.
Thanks,
J
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!