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

Power Pivot

Power Pivot is an Excel plugin which allows you to create a data model. The data model can use several types of data sources, including OData web services, Windows Azure Marketplace, XML files, Excel files, databases, and so on.

I will introduce you to Power Pivot and demonstrate how you can use it to combine several Dynamics NAV OData web services and web services from Windows Azure Market Place into a data model. You can then use this data model to enrich your data and use it when you create reports using pivot tables, Power Pivot reports, Power View, and Power Map.

When you publish an object, such as a page or a query object, as an OData web service you can use it directly to create a report in Excel. But, if you want to create multiple ...

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