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:
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.
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
Hi dcresp,
Based on what I know, Analyze in Excel would only be available under dataset, sharing dashboard won't share the dataset, and exporting data from Reports would only gain access to the data shown in the reports.
By the way, currently it has no available way to disable Analyze in Excel option (Edited, I mean in addition to the method through Admin Portal), you may consider submit an idea on this topic, to allow it work without disable Export data.
Regards
Thanks for the responses. I have established that there is no way to turn off Analyse in Excel which I see as a huge oversight by Microsoft as it gives external users full access to all the data in the data model behind the Power BI report. We are now moving to set up a Power BI embedded structure.
