Is it possible to configure the permissions for a Power Pivot library such that users can reference the Power Pivots as a data source for Excel or Power View, but not "download a copy"?
9
-
What do you mean not "download a copy"? The very idea of being able to view something on the Internet necessitates downloading it. If you only want users to be able to use it as a data source, I think you need to go to SSAS. If the issue is that you don't want users to be able to change the reports even if they download a copy, then I think you would need to look at Information Rights Management.– Robert KaucherCommented Mar 13, 2014 at 13:30
-
I don't think it should necessitate being able to download. I would like users to be able to view the document in Excel Services, and to be able to create a data connection (from Excel or Power View) that references the Power Pivot data. I just don't want them to be able to download the xlsx file that contains the Power Pivot model.– JoeCommented Mar 13, 2014 at 14:43
-
We are using SSAS (Tabular) as well, and we are defining the differences between Tabular and PP. It is looking like this might be one -- if we can't prevent folks from downloading a Power Pivot cube.– JoeCommented Mar 13, 2014 at 14:47
-
This is a fundamental aspect of the Internet. If a person has read access to a file, they can download it.– Robert KaucherCommented Mar 13, 2014 at 16:28
-
@RobertKaucher That is true for static file types such as Word or PDF, for which the entire source file must be transferred to the client in order to be displayed. But it's not true for data sources, such as PP. If I create a new Excel doc with a data connection to a published Power Pivot file, then only the data that meets the query criteria must be transferred. That is, I don't need to transfer the entire Power Pivot source file (xlsx) to the client.– JoeCommented Mar 13, 2014 at 16:33
|
Show 4 more comments
1 Answer
According to this link - Disable Send To and Download a Copy options for files? - it's not possible.
Go to the list and go to List Permissions, break inheritance and set the users/groups of your choosing to only have read permissions. This will make it possible for them to see the items in the list but not interact with them.
