Integrations with Files and Services

[PMI_NEIL]

Hi, I have Dynamics NAV 2017 on prem and want to connect to it via the Dynamics Nav PowerBi app in Office 365. I enter the Odata URL and click on  'Next' but no matter what authentication method i use i cannot connect to my on prem NAV solution. The error i recieve is 'Failed to update data source credentials'  - Status Code 400. Has anyone successfully connected in this way before? Many thanks

[v-yuezhe-msft · Accepted solution]

Hi @PMI_NEIL,

Generally, the content pack is used to connect to online Dynamic NAV, and only Basic (Username and Password) authentication is supported.

In your scenario, you are using on-premises Dynamic NAV, you can check if the content pack works after turning your solution's authentication.


Thanks,
Lydia Zhang

[v-yuezhe-msft]

Hi @PMI_NEIL,

Do you get error when using the Microsoft Dynamics NAV content pack to connect to your data source? If so, could you use the Get Data->OData Feed entry in Power BI Desktop to connect to Dynamics NAV and check if it is successful?

In Power BI Desktop, you can create reports and publish the reports to Power BI Service.

Thanks,
Lydia Zhang

[PMI_NEIL]

Hi Lydia,

Thanks for the reply, i do know about that way of publishing the data, but i was really interested in the pre set of reports that the NAV app would provide once connected to our NAV solution.

I'm now thinking this will only work if i turn my solution's authentication from 'windows' to 'username' which i wont do.

best regards

Neil

[v-yuezhe-msft · Accepted solution]

Hi @PMI_NEIL,

Generally, the content pack is used to connect to online Dynamic NAV, and only Basic (Username and Password) authentication is supported.

In your scenario, you are using on-premises Dynamic NAV, you can check if the content pack works after turning your solution's authentication.


Thanks,
Lydia Zhang

[PMI_NEIL]

Hi Lydia,

Thanks again for replying, what do you mean by "online Dynamics NAV". our solutions web services and Odata and soap services are all fully accessible via the internet, and i dont believe Microsoft provide an online NAV service as yet?

thanks

Neil

[v-yuezhe-msft]

Hi @PMI_NEIL,

It depends that how you deploy Nav, if you deploy Nav in the cloud, it is online, for more details, you can check this blog: http://erpsoftwareblog.com/cloud/2017/03/dynamics-nav-choose-deployment-model-best-suits-business/.

Thanks,
Lydia Zhang