Publishing your NAV dashboard to the Power BI portal

After the creation of a Power BI report with the desktop application, here we want to create a Power BI dashboard and publish it on the PowerBI.com website by performing the following steps:

1. Let's start by opening the Microsoft Dynamics NAV Development Environment and for this sample we'll use the NAV query, Top Customer Overview (object ID = 100):

   

2. From the NAV RoleTailored Client, open the Web Services page and publish this Query object as a web service:

   

3. Copy the web service OData URL and on the Power BI Desktop click on Get Data | OData Feed. Paste the OData URL and click OK (here I've used the IP address but it's better to use a fully qualified domain name).

   The Power BI Desktop may show you this message:

   

4. If so, click on the desired authentication tab on the left and insert the correct credentials:

   

   Power BI will load the NAV data via the OData web service and you will see the dataset in the right pane:

   

5. We can start adding visuals...