cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
isabtogumon
New Member

Connect Dynamics NAV and Power BI

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.

 

PBI.jpg

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@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:

 

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

View solution in original post

2 REPLIES 2
BIisPower
Regular Visitor

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
Community Support
Community Support

@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:

 

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors