cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Murrgh
Regular Visitor

Dynamics NAV Connection Issue: "We couldn't authenticate with the credentials provided."

I'm trying to connect Power BI desktop to our on premise NAV 2017. I've followed Microsoft's guide and done some searching, but am unable to get it connected.

 

In NAV, I'm copying the ODATA URL under Web Services directly into the ODATA URL feed on Power BI. I enter our company name as it appears in NAV and press "OK".

 

It asks for my username and password. I ender it in as follows <domain>\<user account> and utilize the web services access key retrieved from NAV.

 

Once I select "Connect" it says, "We couldn't authenticate with the credentials provided. Please try again."

 

Any ideas on where to go next?

2 REPLIES 2
Community Support
Community Support

Re: Dynamics NAV Connection Issue: "We couldn't authenticate with the credentials provided.&quo

Hi @Murrgh ,

 

Based on this document, what is the authentication options you choose to connect? Please try to use <user account> with the basic authentication. Please try to verify if you can access the same nav server by using the same credential and other official tools.

 

Based on this document: https://docs.microsoft.com/en-us/dynamics-nav-app/madeira-powerbi#accessing--in-power-bi

To access your Dynamics NAV data in Power BI, on the connection page, you must specify the following information:

Field Description
OData Feed URL The OData URL so Power BI can access data from your company, such as https://mybusiness.financials.dynamics.com:7048/MS/ODataV4/Company('My%2Business').
Authentication method Choose Basic.
User name Your name as it displays for your account in Dynamics NAV, such as John Smith.
Password This is the web service access key for your user account in Dynamics NAV.

 

Please check the format of OData URL and your user name.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
Community Support

Re: Dynamics NAV Connection Issue: "We couldn't authenticate with the credentials provided.&quo

Hi @Murrgh ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors