Connecting to Microsoft Dynamic Nav from Power BI in a intranet?

Hi,

 

I would like to know how can I connect to Microsoft Dynamic Nav from Power BI. The Microsoft Dynamic Nav is installed locally on a server in another place, it is not on Office365. We use a remote connection to go inside NAV whe we need to do something.

Now I have been asked to create some rapports using Power BI so my first step was go to Microsoft and find information to get connected to Nav from Power BI. I found that the URL needed look like this: 

https://[navserver]/[instance]/OData/Company('Sample%20Company')

  which is completly different that the URL we use to connect to NAV. Our NAV address to the server looks like a regular URL: https://nav.address.com so I can't use that URL to connect from Power BI. 

What other methods can I try to connect to NAV? 

Best regards

Americo