PowerView Issue

Question

Unable to create PowerView Reports

I got the error message below once I click on the Create PowerView Icon.Error

An unexpected error has occurred.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 0e4af061-c777-490e-b50d-688be6beb0a1

Date and Time: 3/30/2012 3:22:27 AM

---

hussain

Answer 1

Hi,

Are you able to open the power pivot workbook and are the pivot tables(if it has) working fine?

You may need to check whether all the share point services and apps in app pool are running fine.

You can get the detailed info by checking the share point logs.

=========================

Please mark as answer helpful

Answer 2

PowerPivot is working fine ONLY PowerView not working at allllll

HELP plz

---

hussain

Answer 3

Hussain,

Review your sharepoint logs and search for the correlation ID.  That will bring you to a more specific set of events (and hopefully errors) that occurred under the covers. You may find the ULS Log Viewer on CodePlex helpful in reviewing these logs: http://ulsviewer.codeplex.com/

Also keep in mind Power View is enabled by SSRS Integrated mode.  Does SSRS Integrated work in this farm?  If it doesn't you need to start there and get those components working. 

So, test SSRS/Integrated, and look at the SP Logs.  If you find the correlation ID in the logs, pasting a section of the SP log around the correlation ID here may help others better spot a root cause of failure.

Best regards,

Rob

---

Rob Kerr SQL Server MVP CTO, BlueGranite

Answer 4

This can be becuase of any of following issue

1) your pivot table column property  mapping has not done properly

2) it may be happend because of data issue.

i encountered this issue becouse of data issue, what i have done, i would suggest download excel plug-in for http://www.microsoft.com/en-us/bi/powerpivot.aspx then create simple pivot table then try to create then go for complex one, this way you can know whether it is issue with something else or above points only.

Regards

Ram Pawar