NAV 2016 - NAV Content Pack - Won't Install

[skacheech]

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

[Ashique]

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.

[v-yuezhe-msft]

@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

[skacheech]

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

[v-yuezhe-msft · Accepted solution]

@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]

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.

[v-yuezhe-msft]

@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,

[shahtrading]

Hi,

I'm having same issue.

So to clarify - you are saying the content pack will not work for on premise installation of NAV?

they were written in 2015. I'm not sure how many cloud installations there were then..

Could it possibly problem with using them with NAV 2017?

[shahtrading]

Hi,

I'm having same issue.

So to clarify - you are saying the content pack will not work for on premise installation of NAV?

they were written in 2015. I'm not sure how many cloud installations there were then..

Could it possibly problem with using them with NAV 2017?