Forum Discussion
NAV 2016 - NAV Content Pack - Won't Install
Hello I have a NAV 2016 environment that I wanted to run the NAV Content Pack for.
When I try to get this Content pack using the instructions in the link:
https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/
I get to step 5 (i type in my OData URL which I know is working, my windows username and password that has admin rights in NAV) and click sign in, and the loading circle just hangs. I've waited overnight and still it just sits there.
I read some things about having a personal gateway so i tried to install it but the installation failed could this be related). Now i don't see that step in the official link provided. Is this what is preventing me from accessing my NAV data?
I really need to get access to this NAV Content as the client is expecting it.
Any help would be appreciated.
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,
8 Replies
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,
LydiaLydia, 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,
Hi,
I'm also having the same issue.
I have installed the on-premises data gateway. The Power Bi service indicates the connection is successful.
But still I can't connect to the content pack, the loading circle just hangs.
