Analyze in Excel should be an option at the report level
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!!
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.