on 14 Oct 2019 18:10:44
Currently in order to disable Analyze in Excel you have to disable both that feature and Export Data at the tenant level.
We use a lot of drillthrough tables with the only the data fields we want the users to see and they should have the option to Export Data to excel. So in order to disable Analyze in Excel, we have to disable Export Data and that will not work for us. We need the ability to have the option to turn Analyze in Excel on or off at the report level in PBI Desktop or in the Report settings in the Workspace and not at a the tenant level. Just like the option we now have at the report level in PBI and/or at the report settings in the Workspace to allow users to be able to export summarized and underlying data, summarized data only or neither.
Some reports the users have global access and can see all confidential data so they can have the ability to analyze in excel. But other reports where we have RLS in place, Analyze in Excel defeats that purpose and they can see everything in the dataset. We need to be able to turn this off!!
- Comments (3)
RE: Analyze in Excel should be an option at the report level
The ability to disallow "Analyze in Excel" at the report level is critical for survey data. Researchers are required to share survey data in aggregate (i.e. all charts must be based on no fewer than X responses). With a single click, report users can get around this and zoom in on individual responses.
RE: Analyze in Excel should be an option at the report level
I'm sure many enterprises run into the issue where users of one report need the ability to export the data from a certain visual in a report, whether csv or Excel, but the Analyze in Excel feature gives too much access. Other reports need to be able to do both. Making the Analyze in Excel feature option only at the tenant level causes authors to turn off necessary features (export) to secure more sensitive data. If this were at a report/workspace level it would be much more enterprise friendly.
RE: Analyze in Excel should be an option at the report level
This Analyse in Excel feature gives user the power to browse any model in the same AAS server. This creates a spike in the memory and QPU utilization (not by much). When a large number of users does it, it could be a problem as it might take away all the available resources and might slow down our near real time AAS processing.
So the solution we are looking for is to disable the “analyze in excel” feature for the user at the workspace level without taking away their other capabilities like create/edit/publish/download report in the same workspace and should not restrict Analyze in Excel on other workspaces.