Why Microsoft Power BI?
Microsoft’s Power BI is an interactive data visualization tool that can be leveraged to organize and visualize a company’s KPIs. Business Intelligence (BI) tools are a dime a dozen in today’s marketplace, but Power BI is made for integration with Microsoft Dynamics NAV, is a part of the Office 365 suite and is readily available with online access.
Close integration with Dynamics NAV brings added benefits to Power BI, like the ability to embed into Dynamics NAV the same reports as in Power BI while still navigating within Dynamics NAV. Plus, there is the option to use the same username and password for Dynamics NAV, Power BI and other applications using the single Microsoft platform (also known as Single Sign On [SSO]). Beyond these added perks, Power BI offers many other advantages and integrations. Find out more on the Power BI website.
It will show you how to easily set up the Dynamics NAV and Power BI integration without using Microsoft Dynamics NAV content pack for Power BI.
Power BI with Microsoft Dynamics NAV
We have been able to successfully configure Power BI to embed reports in your Dynamics NAV instance, through integrating Dynamics NAV data into Power BI.
For Connecting the Power BI with Microsoft Dynamics NAV we have to follow the below steps
- Register An App In Azure Active Directory.
- Set up Azure Active Directory in NAV.
Register An App In Azure Active Directory
I would like to share the steps to register an app in the Azure Active Directory.
Purpose of app registration
- It is used to integrate the application and service with Azure AD.
- Using Azure App, we can generate the token to authenticate the application.
- If we want to use the Azure AD capabilities, we must register the app.
- After we register the app, we can get the “Client ID, Secret key”.
Steps to register the new application in Azure AD
Follow the below-listed steps to register the application.
URL – https://portal.azure.com/
|Name||Name for the new application. Type in the desired application name.||MSDynamicsNAV110|
|Account type||Leave as Web||Web|
|Redirect URL||Redirect URL.||http://localhost:9080/DynamicsNAV110/OAuthLanding.htm|
|Description||Name for the key. Type in a descriptive name.||Secret Key|
|Expires On||Select Never expire option.||Never expire|
|Value||You will get the key when you click on the save|
Set up Azure Active Directory in NAV
Tech Support from Navisiontech…
On-Demand and On Point
Try Navisiontech Support today! We offer 2 FREE hours of support for nearly ALL versions of Dynamics NAV, from version 3 to Business Central. Our support team is US based and will provide support not only for your ERP system, but also for SQL Server, EDI, supply chain management tools, and even code-level support.