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:
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.
how about Publish To Web?
when in Service, select the Report (not the dashboard) and then in the upper frame on left is the 'File' options - one of which is Publish to Web.
That will give you a URL you can send to external users that does not allow them into the data set.
There is of course other issues in terms of not having any sort of log in controls to it ..... but it is a consideration perhaps....
