Forum Discussion

dcresp's avatar
dcresp
Advocate IV
9 years ago
Solved

Disable Analyse in Excel

We are about to launch a Power BI Dashboard to external users and I have just realised that they will be able to use Analyse in Excel. It is not ideal that they can use Export but having external use...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

     

    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:

todo-claro's avatar
todo-claro
Regular Visitor
8 years ago

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. :(