Under API Selection, select “Power BI Service”. Once the permission page has been opened Click Add. Now Under API Access section select Required Permission Tab.On the Sign-on URL, paste the URL you have copied on step 5.Select “Application Type” Web API to integrate Power BI in the Web Client or Native App if you want to integrate Power BI in the Windows Client.Click Add and give the name of your app e.g.Under More Services search for App registrations and open it.On the left sidebar, scroll down and click on More Services. Click on next and you will have two URLs in the textbox which is Home page URL and Reply URL.Click on it and the setup wizard gets started.Once the Assisted setup page has been opened select the line SETUP AZURE DIRECTORY.Open Dynamics NAV Windows Client and Search for Assisted Setup.Now you can access your report on your PC, Web, Mobile device almost anywhere! Once the report has been developed, then click on publish buttion.

Drag and drop the chart and select the field you want to display in the report.Once you have get the data set select the table.Truncate that URL till the company name e.g (‘CRONUS_INTERNATIONAL) Paste the URL you have copied in step 5.Click on Get Data and select OData Feed.Open Power BI Desktop Application and sign in with your power BI credentials.Copy the URL available in oData field on the Web service page.Expose the Objects as an OData Webservice in Dynamics NAV for which you want to make a Power BI report (for instance: Sales Dashboard).Under Client Services Fast tab mention the public base URL in the Web Client and Windows Client field and click Save.

Go to the Dynamics NAV Administration Console.

First of all download and install Power BI Desktop.

This is important because if you don’t you will not able to register power BI app in Azure App registration portal.

You must have azure subscription on the same id on which you have subscribed power bi.

If you do not have Power bi subscription then sign up for power bi free version here This machine should be available on the internet (it should have open ports for the OData service of dynamics nav service tier ).

You must have Dynamics NAV 2017 installed on a machine.

In Dynamics NAV 2017, Microsoft introduced the functionality to integrate power BI with dynamics NAV. The purpose of this post is once we developed the report on power bi then how we can see in dynamics nav. PowerBI is a great reporting tool which allow us to make interactive reports, 3D charts. Today I am writing another post on the topic how to connect power bi with Microsoft dynamics NAV 2017.

Nav 2017