Microsoft Dynamics NAV with PowerBI.com


Have you explored Microsoft PowerBI.com yet? Power BI helps bring data to life! Power BI is a Microsoft’s Business Analytics service for Visualizing, exploring and deriving insights from data!

Sample Power BI dashboard

Please visit http://www.powerbi.com/ to learn more!

Take the Power BI tour at: https://powerbi.microsoft.com/en-us/tour

With the release of Microsoft Dynamics NAV 2016, Microsoft has introduced a new capability called a PowerBI Content Pack so that Microsoft Dynamics NAV end users can connect a correctly configured Microsoft Dynamics NAV instance to PowerBI.com and see a full business performance insights dashboard.

In NAV 2016 demo database, some of the web services are published by default and the Power BI Microsoft Dynamics NAV content pack uses Microsoft Dynamics NAV’s web services to retrieve your data:

Capture3

Pre-requisites:

  • Microsoft Dynamics NAV 2016 hosted on Azure VM
  • Use Authentication method as NAVUserPassword to login to NAV
  • Enable ODATA and SOAP web services in NAV Admin tool
  • Make sure the above specified web services are published in NAV
  • Sign up for an account in PowerBI.com using your organizational email address.

Steps:

1.Sign in to PowerBI.com and Click on Get Data

2.Select the content package for Microsoft Dynamics NAV.

Dynamics NAV Content Pack

3. Click on Connect and enter the NAV 2016 OData URL feed as : http://domainname:port/Instancename/Odata/Company_name

Example: http://nav123.cloudapp.net:7048/NAV/OData/Company(‘CRONUS%20International%20Ltd.’)

4. Choose the Authentication Method as Basic and enter the NAV user ID and Password to Sign in.

This creates Microsoft Dynamics NAV Dataset, Report and Dashboard as shown below:

Capture4

Each report contains multiple charts for a given set of data. Users can modify, copy to new, or create new content on the pages to get KPIs and charts from the data that fits their individual needs. Users can pin report elements to their existing dashboard or they can create a new dashboard.

More details at: https://support.powerbi.com/knowledgebase/articles/746439

 

 

 

 

 

 

 

 

Advertisements

8 thoughts on “Microsoft Dynamics NAV with PowerBI.com

  1. If only it was so simple! We have been trying for days to get this to work. After working out that there is an issue with the Web Service KPI setup page (page would not run from client to start with plus running odata from browser produced an error), we finally got excited it was going to work. But O no…. it still comes up with error 200 after its creates datasets, reports and dashboard. After reading loads of posts it seems that it is a proof of concept rather than a well designed content pack. How does Microsoft expect Partners to promote this when them themselves can’t be bothered to provide us with a working product. BTW running Demo VM in azure en-GB… Like to add nice post though, thank you 🙂

    Like

  2. Pingback: Connecting Dynamics NAV 2013/2015 to the NAV Content pack in PowerBI.com | Suvidha-blogpost

  3. thanks for the post mr suvidha.

    can u be clear and prescise on this point for me …we have been trying this on NAV 2015. it seems our services ODATA,& SOAP was not configured by default. any advise on this…and how can we make it work. is it that NAV 2016 is much better….after installing…with the services we need to connect to BI…all are installed by default.?? pls…clarify this for me

    Like

  4. Pingback: Connecting Dynamics NAV 2013/2015 to the NAV content pack in PowerBI.com - suvidha - Site Home - MSDN Blogs

  5. Pingback: Dynamics NAV with Power BI | Roberto Stefanetti NAV Blog

  6. Pingback: Dynamics NAV with Power BI - Roberto Stefanetti's NAV Blog - Dynamics NAV Users - DUG

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s