Skip to main content

Consuming Output of ODATA - Part 1

Hi all,

As discussed in earlier post today we will try to consume output from the ODATA Services.

The best tool that i like for same is Power Pivot, an Microsoft Excel add in.

You can download same from link - Power Pivot

After installing the add-in lets try to consume the output from ODATA Service hosted yesterday for Customer Card.

Here is the URL - http://localhost:7048/DynamicsNAV70/OData/NAVCustomers

Steps -
1. Open Excel.
2. You will find a new tab in Ribbon called Power Pivot as shown below.

3. Click on PowerPivot Window, icon placed at left corner of the screen.
4. A new window will open as shown.

5. The Power Pivot Addin can accept data from Multiple sources like Text, Access, Database and many others. For ODATA we will be using the From Data Feeds.

6. Click on From Data Feeds.
7. Type in the Friendly Name and Copy the URL from above to Data Feed URL.
8. Click Test Connection.

9. Click Next and then finish.
10. After some time you will find that data Feed have been imported and status will tell you the no of rows transferred.

11. Now all the data from customer table is there in excel, most of customer find it easy to do analysis here.
12. From time after time you can refresh the data to find update in navision.

13. From this you can create Pivot Tables & charts which can be accessed via ribbon of power pivot.
16. With Excel 2010, the Pivot charts are also too good with Slicer as you can see in the Left and Right Part of the Pivot Chart below.

The slicer can be added, by selecting the pivot chart and then from ribbon select analyze Tab.
Here you will find menu to insert slicer.

You can save the sheet and see the changes by updating the Power pivot whenever required.

I hope you will like the post. We will see other consumption uses of ODATA Feed in future posts.

Saurav Dhyani


  1. Knowing that, as from 2013, PowerPivot is only available with Office Professional Plus (and no longer for all retail SKUs of Office as it is in 2010), what other tool would you recommend to consume output from the ODATA Services ?

  2. Hi,

    ODATA can be used with Sharepoint & C#.

    For C# Consumption of OData Please refer article in Archer Point.

    Saurav Dhyani


Post a Comment

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.