SSRS 2012 Power View Permissions Issue
Hi I wonder if someone good help... I have a single Windows Server 2008 R2 box running SharePoint 2010 on SQL 2012, with SSRS 2012 running in SharePoint integrated mode. On the same box I have an instance of SSAS running in tabular mode with a simple BISM deployed. My domain account is the SharePoint Admin, has ful control over the SharePoint site, has admin rights on SQL database engine and SSAS, I even have full rights on the BISM via a role membership. I have created a BISM connection in a library on SharePoint and the connection tested successfully. When I click the connection to startup Power View, Power View opens but I am present with: The permissions granted to user "MYDOMAIN\myusername" are insufficient for performing this operation... I've spent the last day going over may blogs focusing around this error, but as yet have not come across a successful solution. Any guidance/suggestions would be greatly appreciated. Regards Anthony
October 24th, 2012 7:03am

There is flow of the user identity for the BISM if Kerberos is configured properly the identity will flow, if not Reporting will try to use the effectiveusername and only a member of system administrator role in Analysis Services have permissions to do it. If you want to discard this issue give to the Reporting Services Identity permissions in AS (you can check the RS account in SharePoint Central Admin, Application Management , Manage Service Applications) The full details are here http://technet.microsoft.com/en-us/library/gg471575.aspx under the section Connecting from Power View to tabular data on a network Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2012 12:06pm

Hi Jaime, Thanks for the response. I pretty certain that kerberos hasn't be configured correctly, if at all and unfortunately thats not something I've got much control over. I've actually found read that technet article this afternoon and added the reporting RS service account as sys admin on the AS instance as suggested. Unfortunately I still seem to be getting the same issue.
October 24th, 2012 12:36pm

You will have more ideas what is going wrong if you check the Reporting Services Logs in \Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\LogFiles Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2012 12:45pm

Have you run a trace on the SSAS server to see what credentials if any are being pass through when you try and launch Power View? You mentioned that you do have full control in the site. The reason I mention this is because if you only have View Only permissions you will not be able to use Power View, you need to be part of the Restricted Readers as well which provides the Open Items SharePoint List permission. That is required to run Power View because of Silverlight. Just something to watch out for. If you don't see anything in the SSRS logs check out the SharePoint logs as well. See what is being recorded. If you don't have a tool to view the logs take a look at this one on CodePlex - http://sharepointlogviewer.codeplex.com/
October 26th, 2012 1:57pm

Have you run a trace on the SSAS server to see what credentials if any are being pass through when you try and launch Power View? You mentioned that you do have full control in the site. The reason I mention this is because if you only have View Only permissions you will not be able to use Power View, you need to be part of the Restricted Readers as well which provides the Open Items SharePoint List permission. That is required to run Power View because of Silverlight. Just something to watch out for. If you don't see anything in the SSRS logs check out the SharePoint logs as well. See what is being recorded. If you don't have a tool to view the logs take a look at this one on CodePlex - http://sharepointlogviewer.codeplex.com/
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2012 1:59pm

Have you run a trace on the SSAS server to see what credentials if any are being pass through when you try and launch Power View? You mentioned that you do have full control in the site. The reason I mention this is because if you only have View Only permissions you will not be able to use Power View, you need to be part of the Restricted Readers as well which provides the Open Items SharePoint List permission. That is required to run Power View because of Silverlight. Just something to watch out for. If you don't see anything in the SSRS logs check out the SharePoint logs as well. See what is being recorded. If you don't have a tool to view the logs take a look at this one on CodePlex - http://sharepointlogviewer.codeplex.com/
October 26th, 2012 1:59pm

Have you run a trace on the SSAS server to see what credentials if any are being pass through when you try and launch Power View? You mentioned that you do have full control in the site. The reason I mention this is because if you only have View Only permissions you will not be able to use Power View, you need to be part of the Restricted Readers as well which provides the Open Items SharePoint List permission. That is required to run Power View because of Silverlight. Just something to watch out for. If you don't see anything in the SSRS logs check out the SharePoint logs as well. See what is being recorded. If you don't have a tool to view the logs take a look at this one on CodePlex - http://sharepointlogviewer.codeplex.com/
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2012 1:59pm

Hi guys, Thank you very much for the responses. Unfortunately this task has been put on the back burner for the time being as some other priorities have come up. When I get back round to looking it at this I shall take a look at the logs as per your suggestions. Thanks Again Anthony
October 30th, 2012 5:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics