Connecting Dynamics NAV from Power BI

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 / PowerApps

I 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 NavUserPassword

Database Tab:

• Same setings as Main NAV service

Client Services Tab - NOT enabled
SOAP & Odata Tab - 

• Both enabled
• Port: 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: 

• enabled
• update port to any not used, i set mine to 8245

Then 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 service

create 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 Data

choose Dynamics NAV

use 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 experts,

Did you find a solution for this problem

We are also facing the same issue. Does anyone find a soultion?

Hello all,

I work with microsoft NAV2017 an di try to connect it with power BI, but i can't.

My subcontractor who work for us tell me that microsoft killed the link between NAV2017 and power BI.

Is it right?

What can i make?

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 / PowerApps

I 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 NavUserPassword

Database Tab:

• Same setings as Main NAV service

Client Services Tab - NOT enabled
SOAP & Odata Tab - 

• Both enabled
• Port: 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: 

• enabled
• update port to any not used, i set mine to 8245

Then 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-power...

Once that is done. you will need to Start / restart you new NAV service

create 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 Data

choose Dynamics NAV

use 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.