- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 06:26 AM - edited 04-20-2017 06:27 AM
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.
Accepted Solutions
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-24-2017 02:08 AM - edited 04-24-2017 02:10 AM
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
All Replies
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 11:16 PM
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
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-24-2017 01:37 AM
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
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-24-2017 02:08 AM - edited 04-24-2017 02:10 AM
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
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-24-2017 02:22 AM
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
Re: Unable to connect Dynamics NAV PowerBi app to NAV 2017 on prem
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-24-2017 02:29 AM - edited 06-20-2017 01:21 AM
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