Connect Dynamics NAV and Power BI

[isabtogumon]

Good day,

I have a problem to make the connection to Dynamics NAV from Power BI, this happens from the desktop application and from the online version. I hope someone can guide me to make this connection.

Note: Make the connection with the Windows credentials with and without the name of the computer, in addition a Dynamics NAV user was used, both accounts have administrator permissions.

Thanks in advance.

[BIisPower]

I encountered exactly the same issue here. The message reads, 'We couldn't authenticate with the credentials provided. Please try again'. If any one here successfully solved the issue, can you please share how? I have tried with the variations of credentials combinations I can think of, but to no avail. I believe the username is e-mail address and password needs to be web service key. Any help here will be greatly appreciated.

[v-yuta-msft · Accepted solution]

@isabtogumon ,

What does the error message say? You may refer to troubleshooting steps below:

"Parameter validation failed, please make sure all parameters are valid"
If you see this error after typing your Microsoft Dynamics NAV URL. Make sure the following requirements are satisfied:

• The URL follows exactly this pattern:

  https://instance.navserver.com:7048/DynamicsNAV90_Instance1/OData/Company('CRONUS%20International%20....')

  • "instance.navserver.com" with your NAV Server name
  • "DynamicsNAV90_Instance1" with your NAV Server Instance name
  • "Company('CRONUS%20International%20Ltd.')" with your NAV Company name

• Make sure all the letters are lower case.

• Make sure the URL is in 'https'.

• Make sure there are no trailing forward slash at the end of the URL.

"Login failed"
If you get a "login failed" error after using your Microsoft Dynamics NAV credentials to login, then you may be hitting one of the following issues:

• The account you are using doesn't have permissions to retrieve the Microsoft Dynamics NAV data from your account. Verify it is an admin account and try again.
• The Dynamics NAV instance you're trying to connect to doesn't have a valid SSL certificate. In this case you'll see a more detailed error message ("unable to establish trusted SSL relationship"). Note that self-signed certs are not supported.

"Oops"
If you see an "Oops" error dialog after you pass the authentication dialog box, Power BI is running into an issue while loading the data.

• Verify the URL follows the pattern specified above. A common mistake is to specify:

  https://instance.navserver.com:7048/DynamicsNAV90\_Instance1/OData

  However, you need to include the 'Company('CRONUS%20International%20Ltd.')' section with your NAV Company name:

  https://instance.navserver.com:7048/DynamicsNAV90\_Instance1/OData/Company('CRONUS%20International%2....')