Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Hi,
Were you able to connect NAV (on Prem) to Power BI ? Please let me know if you have followed some work arounds.
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
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.