Skip to main content

    Power BI

    Needs Votes

    Disable Analyze in Excel feature without disabling 'Export Data'

    Vote (97) Share
    's profile image

    on 10 Aug 2017 19:54:46

    Currently under the Tenant Administrative Settings, disabling 'Analyze in Excel' does not prohibit users from using the tool. The only fix is to also disable 'Export Data'. A tool which I would like to keep since it only shares data that is explicitly included in my report, and none of the underlying data.

    Comments (12)
    's profile image Profile Picture

    Chuck Dokmo on 05 Jul 2020 23:10:41

    RE: Disable Analyze in Excel feature without disabling 'Export Data'

    It would be great to have a toggle for enable/disable Analyze in Excel -- by dataset, report, dashboard when publishing an App in Power BI Service.

    Agreed with the other person's comment -- this is important to protect certain underlying data tables.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:05:06

    RE: Disable Analyze in Excel feature without disabling 'Export Data'

    This is a must to protect underlaying data in the model