Packt+ | Advance your knowledge in tech

0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Extending Microsoft Dynamics NAV 2016 Cookbook

You're reading from Extending Microsoft Dynamics NAV 2016 Cookbook Extend Dynamics NAV 2016 to win the business world

Product type Paperback

Published in Jan 2017

Publisher Packt

ISBN-13 9781786460608

Length 458 pages

Edition 1st Edition

Languages

C#

Tools

Dynamics NAV

Concepts

Enterprise Resource Planning

Author (1):

Alexander Drogin

View More author details

Table of Contents (11) Chapters

Preface

1. Writing Basic C/AL Code FREE CHAPTER

2. Advanced C/AL Development

3. Reporting and Data Analysis

4. .NET Interoperability in C/AL

5. Extending C/AL with COM Components

6. SharePoint Integration

7. Control Add-ins

8. Web Services

9. Events and Extension Packages

10. PowerShell

Retrieving data from NAV with Power Query

Power Query is a tool for retrieving data from various data sources, which enables the user to transform, purify, and merge data with ease. Power Query is used to load data into analytical tools, such as Power BI. Data analysis in Power BI is the topic of several recipes to follow, and now we will configure a query to import data into Excel.

Getting ready

If your Microsoft Office version is 2016, Power Query is already a part of the standard setup, no additional steps are required.

For earlier versions of Office, Power Query must be installed separately. It is available for downloading on microsoft.com.

Note

Note that examples in the current and subsequent recipes are based on Office 2016. The Power Query Excel add-in is accessed in the Data ribbon tab in this version. In Excel 2010 and 2013, Power Query actions are located in the ribbon in the Power Query tab.

How to do it...

In this recipe, we will use Power Query to export a list of customers with total...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Alexander Drogin

Alexander Drogin

Alexander Drogin started working with Navision Attain version 3.01 in 2002 as a software developer at a consulting company. After seven years of development, he shifted his focus to end-user support. In 2012, he joined the Microsoft Russia development team as a software engineer in testing, and worked on NAV test automation and sustained engineering tasks. He currently works as a NAV technical architect for a Microsoft partner in Malta.

See other products by Alexander Drogin

Other recommended products

Related to this chapter

Microsoft Dynamics NAV Development Quick Start Guide

Microsoft Dynamics NAV Development Quick Start Guide

Microsoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems through customizing business processes.

Building ERP Solutions with Microsoft Dynamics NAV

Building ERP Solutions with Microsoft Dynamics NAV

Mar 2017 13h 4m

Programming Microsoft Dynamics NAV

Programming Microsoft Dynamics NAV

Microsoft Dynamics NAV is a full business solution suite, and a complete ERP solution, which contains a robust set of development tools to support customization and enhancement. These tools help in greater control over financials and can simplify supply chain, manufacturing, and operations. This book will take you from an introduction to Dynamics NAV and its integrated development tools to being a productive developer in the Dynamics NAV Development Environment.

Apr 2017 23h 32m

Programming Microsoft Dynamics NAV

Programming Microsoft Dynamics NAV

Microsoft Dynamics NAV is a full business solution suite, and a complete ERP solution, which contains a robust set of development tools to support customization and enhancement. These tools help in greater control over financials and can simplify supply chain, manufacturing, and operations. This book will take you from an introduction to Dynamics NAV and its integrated development tools to being a productive developer in the Dynamics NAV Development Environment.

Apr 2017 23h 32m

Programming Microsoft Dynamics NAV

Programming Microsoft Dynamics NAV

Microsoft Dynamics NAV is a full business solution suite, and a complete ERP solution, which contains a robust set of development tools to support customization and enhancement. These tools help in greater control over financials and can simplify supply chain, manufacturing, and operations. This book will take you from an introduction to Dynamics NAV and its integrated development tools to being a productive developer in the Dynamics NAV Development Environment.

Apr 2017 23h 32m

Programming Microsoft Dynamics NAV

Programming Microsoft Dynamics NAV

Microsoft Dynamics NAV is a full business solution suite, and a complete ERP solution, which contains a robust set of development tools to support customization and enhancement. These tools help in greater control over financials and can simplify supply chain, manufacturing, and operations. This book will take you from an introduction to Dynamics NAV and its integrated development tools to being a productive developer in the Dynamics NAV Development Environment.

Apr 2017 23h 32m

Dynamics 365 Business Central Development Quick Start Guide

Dynamics 365 Business Central Development Quick Start Guide

Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.

Aug 2018 7h 28m

Dynamics 365 Business Central Development Quick Start Guide

Dynamics 365 Business Central Development Quick Start Guide

Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.

Aug 2018 7h 28m

Dynamics 365 Business Central Development Quick Start Guide

Dynamics 365 Business Central Development Quick Start Guide

Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.

Aug 2018 7h 28m

Dynamics 365 Business Central Development Quick Start Guide

Dynamics 365 Business Central Development Quick Start Guide

Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.

Aug 2018 7h 28m

Implementing Microsoft Dynamics 365 Business Central On-Premise

Implementing Microsoft Dynamics 365 Business Central On-Premise

Microsoft Dynamics Business Central is a complete ERP software solution for all kinds of organizations. It is fast to implement and easy to configure and use. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book details new features and functionalities available in Dynamics Business Central and NAV.

Dec 2018 25h 28m

Implementing Microsoft Dynamics 365 Business Central On-Premise

Implementing Microsoft Dynamics 365 Business Central On-Premise

Microsoft Dynamics Business Central is a complete ERP software solution for all kinds of organizations. It is fast to implement and easy to configure and use. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book details new features and functionalities available in Dynamics Business Central and NAV.

Dec 2018 25h 28m

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Architecting Salesforce Success

Architecting Salesforce Success

This book provides you with a roadmap to becoming a successful Salesforce Architect. Covering common pitfalls and valuable insights, this book prepares you to transition to the role of a Salesforce Architect.

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design walks interior designers and architects through SketchUp Pro and Studio at an intermediate+ level, covering topics and tools specific to the world of design.

Jun 2024 19h 56m

Power Platform and the AI Revolution

Power Platform and the AI Revolution

Learn how to integrate cutting-edge AI technology into business operations and tap into AI services within Power Platform to enable automation and develop apps and chatbots to achieve heightened productivity and efficiency.

May 2024 11h 52m

Mastering Project Management with ClickUp for Work and Home Life Balance

Mastering Project Management with ClickUp for Work and Home Life Balance

This book will guide you in using ClickUp to become a power user of your life. You'll learn practical strategies for setup, project management, and AI integration to optimize workflow, boost productivity, and manage time effectively.

Jun 2024 10h 16m

Mastering UI Development with Unity

Mastering UI Development with Unity

With Unity's robust toolkit, you can create visually appealing UIs to give your games a professional look and feel. This book will help you realize the full potential of the UI systems provided by Unity, so you can create the best UI for your games.

Jun 2024 21h 16m

Autodesk Civil 3D 2025 Unleashed

Autodesk Civil 3D 2025 Unleashed

This book is a comprehensive guide to using Autodesk Civil 3D. You'll progress from design customization with extensions and information management to project extension, preparing you for a successful career in civil engineering.

Jul 2024 10h 28m

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud covers every facet of the platform, from technical reviews to implementation, business transformation, and long-term growth strategies. Learn to maximize the potential of Salesforce Experience Cloud.

Oct 2024 10h 56m

Mastering the Art of Sales Engineering

Mastering the Art of Sales Engineering

This book covers what a sales engineer is and does, and why this is a highly paid and coveted role. The authors share their vast experience to help you learn daily operations and skills to advance your sales career.

Sep 2024 10h 32m

Taking Tinkercad to the Next Level

Taking Tinkercad to the Next Level

Tinkercad users familiar with the basic functionality will learn to create complex shapes and multi-part designs with this book on advanced modeling. It covers strategies and techniques for modeling and designing for production with 3D printers.

Sep 2024 13h 56m