Introduction

Power View is a new reporting tool that was introduced by Microsoft with the release of Microsoft SQL Server 2012. Unlike many of the other reporting tools that are available, this one is designed so that users can create their own dashboards and reports without needing a lot of help, making everyone just a little more productive. Gone are the days where you have to export data from Dynamics AX to Excel, and then create a one-off dashboard when you want to analyze some data. Now you can create a dashboard in Power View, save it, and return to it any time you like.

With the R2 release of Microsoft Dynamics AX 2012, Power View was also embedded directly into the forms allowing users to create dashboards and reports on the fly without even knowing that they are using Power View.

In this chapter we will show how you can use Power View with the Dynamics AX 2012 R2 to create reports, how the users are able to save the reports for others to use, and also how you can export the reports...