I have spent so many hours trying to make the on-line version of PowerBI work with my Danish CRONUS test environment.
I Succeeded J
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 J
Entering the user id and password, the following shows up – which by the way is also 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:
Use your own server name and remove /powerbifinance from the string.
Next the following error occurs:
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 and to get around that, O renamed the company to: CRONUS Danmark AS.
This made my connection string look like this:
And Viola, I’m inn:
So somebody must fix that, either Microsoft or …. Microsoft J