Book Image

Building ERP Solutions with Microsoft Dynamics NAV

By : Stefano Demiliani
Book Image

Building ERP Solutions with Microsoft Dynamics NAV

By: Stefano Demiliani

Overview of this book

Implementing Microsoft Dynamics NAV in the real world often requires you to integrate the ERP with external applications or solve complex architectural tasks in order to have a final successful project. This book will show you how to extend a Microsoft Dynamics NAV installation to the enterprise world in a practical way. The book starts with an introduction to Microsoft Dynamics NAV architecture and then moves on to advanced topics related to implementing real-world solutions based on NAV and external applications. You will learn how an enterprise distributed architecture with NAV at the core can be implemented. Through a series of real-world cases on every topic and every industry (sales, retail, manufacturing, distribution, healthcare, and so on), you’ll see step by step how to efficiently solve a technical problem. These common problems encountered in a NAV implementation will be solved using the entire technology stack that Microsoft offers. By the end of the book, you will have the knowledge to efficiently solve certain scenarios, you will know which is the best solution architecture to propose to a customer and how to implement it.
Table of Contents (17 chapters)
Building ERP Solutions with Microsoft Dynamics NAV
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Loading NAV data on the Power BI desktop


Let's see how the NAV data loads on the Power BI desktop by performing the following steps:

  1. The Power BI Desktop can be downloaded for free from the PowerBI.com website at https://powerbi.microsoft.com/en-us/desktop/.

    The download starts automatically for your Windows OS version you have on your machine.

  2. After it's installed (it's a simple wizard), launch the Power BI Desktop:

    The application starts by presenting a blank desktop. This is the point to start to create an analysis.

  3. In the ribbon toolbar, click the Get Data button and then select OData Feed:

  4. In the OData Feed window, insert the OData URL that comes from NAV:

  5. Now click on OK. If the Power BI Desktop asks you for credentials, enter your credentials by clicking on the specific authentication tab in the opened window.

    When correctly authenticated, the Power BI Desktop connects to the NAV OData service and it shows you the data that it reads from the feed:

  6. Now click on Load to load the NAV...