O'Reilly logo

Extending Microsoft Dynamics AX 2012 Cookbook by Murray Fife

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

Creating a PowerPivot data source for Power View

You can create Power View reports directly off the data within Dynamics AX by building your own personal data sources through Excel and saving them to a PowerPivot gallery in SharePoint. This gives you the flexibility of accessing data that may not be in the existing Power View cubes, including custom tables and fields that you have added, without having to become a DBA and tweak the reporting cubes themselves.

In the following recipe we will work through a simple example of how you can use the PowerPivot add-on for Excel to access inventory information from Dynamics AX, and then save it to a PowerPivot gallery in SharePoint so that we can report off it.

Getting ready

Before you are able to create ...

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