Hi Experts, Any body have idea about the below error while connecting Dynamics NAV from Power BI ? I am using the basic authentication to connect to Dynamics NAV O Data service.

Hello Chiara,I did finally get all this working. It is a bit confusing but just take your time and it will work. 1. create a new NAV Instance on your NAV Server for these Odata and SOAP connections. In the below article this is not clearly called out, but you will need a new NAV service specifically for Power BI / PowerAppsI added a new Instance (service) called NAV2017_NUP, duplicating the main NAV service with some changes as outlined below. General Tab:Enabled SSL (optional) this requires the Certificate Thumbprint but can be the same as your main NAV service so you can just copy that.Credential Type - set to NavUserPasswordDatabase Tab:Same setings as Main NAV serviceClient Services Tab - NOT enabledSOAP & Odata Tab - Both enabledPort: set to a port not used by any other service. my main NAV service - 8047 so I changed these to 8247 & 8248. see pic Management Services Tab: enabledupdate port to any not used, i set mine to 8245Then follow this article on connecting power apps. It would be the same for Power BI.Specifically the parts related to NAV. https://community.dynamics.com/business/b/fajdigainfo/posts/connect-dynamics-nav-and-microsoft-powerapps Once that is done. you will need to Start / restart you new NAV servicecreate your user Id as outlined in above article You will need a port forward rule on your ISP firewall to direct inbound trafic to your NAV server for the Port numbers you used. Now in Power BI, Get Datachoose Dynamics NAVuse the Odata4 URL, userid and pwd from the newly created NAV service Hope this helps and if you need more help let me know. Happy to get on a Teams call.Best Regards,Michael.

Anonymous,Please use Dynamics NAV connector in Power BI Desktop and check if you are able to connect to the data source. In addition, do you add proper firewall rule for the Dynamics NAV port ?Regards.Lydia

Hi Lydia, Thanks for the reply. Please explain what do you mean by adding proper firewall rule for the Dynamics NAV port. I am using the port 3047 to connect to NAV client. Sepratelly, i have kept the windows firewall off. Is this the same you are pointing about? Is there any link which explains the proper firewall rule for the dynamics NAV port ?.

Anonymous,Since you have turned off firewall, it doesn't require to add port to firewall rule. Are you able to connect to the data source in Power BI Desktop?Regards,Lydia

No .. I am getting error in authenticating the credentials.

Connecting Dynamics NAV from Power BI | Microsoft Fabric Community

Forum Discussion

Related content

Connectivity Issue : Power BI to dynamics 365 (Dataverse)

Dynamic ODBC Connection.

How to use dynamic connection password in Power BI

Power BI Oracle Connection Error – ORA-50201 (Failed to connect / parse connect string)

Copy Activity Dynamic Source Connection