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:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dcresp have you validated that the setting in the Power BI Admin Portal "Allow users to Analyze in Excel with on-premises data sets" is turned to "off" - I haven't tested this setting out, but it seems like it may turn this off.

dcresp's avatar
dcresp
Advocate IV
9 years ago

Thanks Anonymous I tried this. This does not seem to work for external users. In fact it does not seem to have worked even for internal users. I expect the issue is that it is a dataset that is not getting refreshed automatically as I do not want external users to have to have Power BI Pro.

 

I am starting to wonder if the only answer to this is to move to Power BI Embedded. Somthing that we were not planning to do just yet.

 

Regards

 

David