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 NAV data for Power BI


In order to use NAV data from Power BI, we need to publish it as OData web services (we want to absolutely avoid direct access to SQL Server tables). The best way to work is to use Query objects. This permits you to query the NAV database and retrieve fields from a single table or from multiple tables (by using join clauses):

  1. We can start by using the standard NAV Query object with ID = 102(Item Sales by Customer):

  2. You can directly run the Query object from the NAV Development Environment and see the following result set:

  3. When your Query is ready to be published, you've to access the Microsoft Dynamics NAV RoleTailored Client and create a new entry on the Web Services page by setting the record as described:

    • Object Type: Query

    • Object ID: 102

    • Service Name: Your desired service name, recommended without using spaces (here it is ItemSalesByCustomer)

    • Published: TRUE

    Your record will appear as follows:

  4. When published, NAV gives you the OData URL. You can check...