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:

GilbertQ's avatar
GilbertQ
Super User
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:

dcresp's avatar
dcresp
Advocate IV
9 years ago

Thank you very much GilbertQ this has worked for us as well. We tried turning off Analyse in Excel but you are correct that you need to turn off teh export feature as well. This is an overly blunt tool as it has now turned both features off for all dashboards which is far less than ideal but we at least have some control. Thank you very much for letting us know the solution.

 

Regards

 

David