Forum Discussion
Disable Analyse in Excel
I can confirm that I now tested removing the ability to Export Data, as well as "Allow users to use Analyze in Excel with on-premise datasets" and waited 10 minutes.
When I went back in, all the options to Analyze in Excel were removed.
Below is what my settings were:
Hello All,
there is a workaround for this on Dataset Level Withot being Andmin or Tentant, and not for all the Organization.
If you hide all (or certain) tables for the report view (right click on table in Data or Relationship view in power BI desktop, then select Hide in Report View, then publish again. ), then Analyze in Excel will not export this tables.
Disadvantage: in Power BI desktop, in order to futher develop the model, you will need to unhide the tables again. :(
This is a information security issue as well!
Think about a huge dataset that potentially covers a lot of use cases and that is used for a report that only uses a small part of that big model. Sharing this single report will expose all data to be analyzed and loaded into Excel. That's not only an issue for external users but vor internals as well because it circumvents permissions a report creator might have in mind when explicitely not including a field into his/her report!
As a report creator we need to explicitly allow this feature to be availlable to the consumers for each report individually! To support the according idea, please vote for it here: