O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required