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