Skip to main content
Microsoft Idea

Power BI

Needs Votes

publish to app - restrict access to "Analyze in excel"

Vote (95) Share
Withold's profile image

Withold on 30 Apr 2018 17:20:36

it would be important for us to have the option to restrict the access to "Analyze in Excel" when publishing to an App.

Comments (5)
Withold's profile image Profile Picture

Sasmit Sharma on 14 Jul 2021 09:38:22

RE: publish to app - restrict access to "Analyze in excel"

Yes, this is required , one of the aim to build a dashboard on Power BI is to restrict users to see the data or aalyze the data & create their own versions of reporting

Withold's profile image Profile Picture

Erik Jahre on 07 Oct 2020 13:56:09

RE: publish to app - restrict access to "Analyze in excel"

For our organisation, we plan to build large datasets and tailor reports to specific user group needs, i.e not showing all columns to everyone. At the same time we want to allow super users to be able to analyse in excel and/or edit reports. This is not doable today, so this idea is very important. On the other hand, I am not sure if prohibiting it when publishing to app will be sufficient - it should be a feature you can control when you publish a report. In that way you can create two reports on the same dataset - one that allows for analyse in excel, and one that does not for different user groups.

Withold's profile image Profile Picture

Karim ABDELOUAHAD on 05 Jul 2020 23:48:03

RE: publish to app - restrict access to "Analyze in excel"

Yes indeed!

Withold's profile image Profile Picture

Daniel on 05 Jul 2020 23:42:43

RE: publish to app - restrict access to "Analyze in excel"

Yes! There needs to be a way to provide just view only access to reports (preferably in apps). It's disingenuous to say that user's can't "download that dataset" when they can analyze in excel.

Withold's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:39:59

RE: publish to app - restrict access to "Analyze in excel"

When reports are shared using either the "Share" oder "App" feature, the dataset is exposed as well. Every recipient (with a Pro-license) is allowed to use "Analyze in Excel" or access the dataset with the "Power BI Publisher". As a report creator I must be able to prevent this!