I have implemented PowerPivot Chart, PowerView and uploaded the same to PowerPivot gallery on BI Site. Excel Services is configured with "Unattended Service Account" to retrive data from Data Source. Currently, I have populated the PowerPivot Data Model based on both SharePoint list and MS SQL Server.

Both SharePoint list and SQL Server has item level/row level permissions set, i.e. the records/data is shown based on current logged-in user's access.

Since I am using Unattended Service Account, I am facing no problem to Show/Filter/Drill down data as the Unattended Service Account has enough privileges to query all data from SQL Server/SharePoint list.

The only way I can think of securing, is to set appropriate access at PowerPivot Gallery library in BI site, appropriate access to SharePoint list/SQL database.

I would like to know whether it is possible to implement item level/row level permissions such that when PowerPivot/PowerView is opened, the data is displayed based on user's access instead of service account.

Another question I have is related to SilverLight. Since PowerView runs on SilverLight and SilverLight going to be deprecated in 2021 (Link), is it still advisable to develop PowerView dashboards in SharePoint.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.