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

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...