Get data from Dynamics NAV 2018

[Hoiikbentim]

Hello,

I'm trying to connect from the Power BI desktop application to a NAV 2018 instance. It seems like this should be possible but I can't get it to work and can't find a working example online to help me figure it out.

We have NAV 2018 installed on an in-house server and Power BI running on my local system.

As far as I can tell I should be able to select the Dynamics NAV online service:


After selecting the source I should enter the value found in the webservice table in NAV in the URL for OData field as described in the image below and click "OK".


In the following screen I should then enter my user name as registered in NAV and my webservice access key.

When trying to connect an error occurs stating the references can't be verified. I've tried entering my username in various ways to try and make the connection but nothing seems to work.

Any help is appreciated, please let me know if/when you need more information.

Thanks in advance, Tim.

[v-yuezhe-msft]

@Hoiikbentim,

How about you use OData feed connector to connect to the data source? You can follow the guide in the blog below.

https://www.1clickfactory.com/blog/how-to-configure-power-bi-for-microsoft-dynamics-nav/

Regards,
Lydia

[v-yuezhe-msft]

@Hoiikbentim,

When you use Dynamics NAV connector in Power BI Desktop, please follow the guide in the article below to get URL, user name and password.

https://docs.microsoft.com/en-us/dynamics-nav-app/across-how-use-financials-data-source-powerbi

Regards,
Lydia

[Hoiikbentim]

Hello Lydia,

Thank you for your reply.

The suggested solution does however not seem to work, I can't get passes step 4 when trying to connect to a NAV 2018 instance.

Any other suggestions are welcome.

[v-yuezhe-msft]

@Hoiikbentim，

Which error message do you get in step 4?

Regards,
Lydia

[Hoiikbentim]

Hello Lydia,

My appologies for the delayed reply, I hope you are still willing to help me out.

The error message says: "We couldn't authenticate with the credentials you provided".

Please let me know if you have any other questions and/or suggestions.

Thanks in advance.