O'Reilly logo

Microsoft Dynamics NAV 2015 Professional Reporting by Steven Renders

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

Using Excel

You can import data from different sources using Microsoft Office Excel, one of which, as from version 2010, is ODATA.

Note

I'm using Excel version 2013 in the demonstrations and examples. Most of it is also possible in version 2010, but I recommend the 2013 version.

Start Microsoft Office Excel, and create a blank workbook. Then, in the ribbon, look for DATA and select From Other Sources, then select the From OData Data Feed:

Using Excel

You need to enter the OData web service URL and the credentials used to access Dynamics NAV in the popup window that opens:

In the next window you will see the Customer Card web service. Select it and click on Next ...

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