Forum Discussion
NAV 2016 - NAV Content Pack - Won't Install
skacheech,
The NAV content pack is for online instance of Dynamics NAV but not for on-premises instance of NAV.
In your sceanrio, you can connnect to on-premises instance of NAV in Power BI Desktop, create reports there and publish the reports to Power BI Service. And when you need to refresh the dataset in Power BI Service, you need to use gateway.
Reagrds,
skacheech,
Do you connect to a on-premises instance of Dynamics NAV or an online instance of Dynamics NAV? Could you please use the Get Data->OData Feed entry in Power BI Desktop to connect to Dynamics NAV and check if it is successful?
Regards,
Lydia
Lydia, thanks in advance for responding.
1. Our NAV instance is On-Premises
2. After some trial and error, I was able to connect to NAV using OData using Power BI Desktop. We created a NAV instance using NAVUserPassword credentials, then created a user. Using this user and using Basic authentication in the Get Data>OData Feed wizard we were able to connect to the CRONUS demo company data.
3. We then tried again to connect to our NAV data using Power BI Online, using Basic authentication, and the user we setup above and it still just hangs. I read something about installing a gateway. Do you know if that should be our next step?
Thanks,
Dan
skacheech,
The NAV content pack is for online instance of Dynamics NAV but not for on-premises instance of NAV.
In your sceanrio, you can connnect to on-premises instance of NAV in Power BI Desktop, create reports there and publish the reports to Power BI Service. And when you need to refresh the dataset in Power BI Service, you need to use gateway.
Reagrds,I'm a little confused. What do you mean an online instance of Dynamics NAV? Can you send me a link with info for that version of NAV.
We have a NAV 2016 environment with OData enabled so that should give us access to the NAV data correct?
The reason we want the NAV Content Pack is because they come with out of the box reports/dashboards which the client will access via the Power BI Online service. We don't want to build those from scratch.
Could you please clarify.
skacheech,
If you deploy Nav in the cloud, it is online, for more details about online Dynamics NAV and on-premises NAV, you can check this blog: http://erpsoftwareblog.com/cloud/2017/03/dynamics-nav-choose-deployment-model-best-suits-business/.
Generally, the content pack is used to connect to online Dynamic NAV, if you are unable to connect to on-premises Dynamics NAV after turning your solution's authentication from 'windows' to 'username', you would need to use the OData entry in Power BI Desktop and re-create reports.
Regards,