Setting up PowerBI Online with Dynamics NAV

I have spent so many hours trying to make the on-line version of PowerBI work with my Danish CRONUS test environment.

I Succeeded [:)]

Now for the rest of you, here is the recipe:

Make a oData SSL connection to your test environment

Remember that, if you have other applications using the standard port 7048, you must change the port to another port, in my case 7148.

Look here to configure the oData for SSL: https://msdn.microsoft.com/en-us/library/ee414240(v=nav.90).aspx

Then set your Dynamics NAV service tier up to handle the new port and the encrypted connection. In this case it the DynamicsNAV90_NUP service that should publish the oData connection on port 7148. The DynamicsNAV90_NUP service has been configured with the NavUserPassword authentication.

 

Next test the connection from inside and outside the firewall.

For testing the inside, copy the content of the oData field and paste it in a browser:

 

This is a good sign [:)]

Entering the user id and password, the following shows up - which by the way also IS a good sign:

Testing from outside the firewall, replace the internal server name with the domain name:

This works too.

Now go to http://powerbi.com

Sign up for an account and log in:

Then click services and browse until you find the Dynamics NAV Content pack:

Now the connection dialog shows up:

To access the oData connection use the url from previous:

https://<internetadr>:7148/DynamicsNAV90_NUP/OData/Company('CRONUS%20Danmark%20A%2FS')

/powerbifinance

Use your own server name and remove /powerbifinance from the string.

Next the following error might occur:

The important part here (I think) is the bad request –Error in Syntax.

That made me think.

The Danish CRONUS name is: CRONUS Danmark A/S, because that is the way Ltd companies are spelled in Denmark. The / in the company name creates the problem and to get around that, I renamed the company to: CRONUS Danmark AS in Dynamics NAV.

Then I changed  my connection string to look like this:

https://<internetadr>:7148/DynamicsNAV90_NUP/OData/Company('CRONUS%20Danmark%20AS')

And Viola, I’m inn:

 

So somebody needs to fix that, either Microsoft or …. Microsoft [H]

 

In the meantime, don't use Special characters in the company name.

 

Anonymous
Parents
No Data
Comment
  • Does the NAV instance/service have to be configured with the NavUserPassword authentication? I have been trying this for days and ours is set to WIndows authentication. Outside the firewall, I can use the Get Data command to connect PowerBI to the NAV data, can also use the NAV Webclient and the Windows 10 client app. However, if I try to create a Connection in PowerApps or use 1 of the NAV content packs in PowerBI, I get authentication issues. Could that be due to the NavUserPassword vs Windows authentication?

Children
No Data
Related