Skip to main content

Power BI

Needs Votes

restrict export to excel

Vote (148) Share
Robert Erickson's profile image

Robert Erickson on 22 Jun 2017 19:55:27

We see that there is a way at the tenant level to restrict the export to excel as well as the analyze in excel but we need an option per dataset (preferred) or per Power BI Report to restrict this option. The problems we are facing is for both sensitive information and also for volumes of data that is too large for this option. We need to have the ability to stop this option for these specific datasets but allow it for other non-sensitive information - so the tenant level option is not appropriate.

Comments (15)
Robert Erickson's profile image Profile Picture

4a3fc996 a08f-435a-b2c4-bc16ccfe2b72 on 05 Jul 2020 22:59:35

RE: restrict export to excel

Separate settings for the application, report and dataset a great option and very flexible. Many of our data sets are too large to be exported but individual visuals in reports are not.

Robert Erickson's profile image Profile Picture

732ee302 fd40-4b22-836f-e3b69594b454 on 05 Jul 2020 22:52:14

RE: restrict export to excel

Export to Excel is indeed a need especially considering our company habits but should in my opinion be disable for large volumes of data. We would then prevent servers to crash and users would not be tempted to export huge lists of data to then analyze it through pivots, just because they feel more comfortable with Excel.
Jorge Carneiro

Robert Erickson's profile image Profile Picture

22c8a0f5 360f-4311-9da7-f78e9d73b4ab on 05 Jul 2020 22:51:53

RE: restrict export to excel

This would be great to have!

Robert Erickson's profile image Profile Picture

9ea92c74 0c0a-455a-917f-440b20af1aee on 05 Jul 2020 22:51:50

RE: restrict export to excel

Power BI is an amazing platform but Excel is the most widely used data analysis tool so far. Lots of users need to see data in Excel, so the option to export data to Excel is very handy. If the strong security control capabilities of Power BI can be applied to this data export feature, it would be great. Please also offer more options for choosing the datasets of choices. I strongly support this idea.

Robert Erickson's profile image Profile Picture

272a0072 71c5-43a1-9180-21f1882fd52a on 05 Jul 2020 22:51:49

RE: restrict export to excel

Completely Agree this would save a lot of time and enable us to put more SSRS requests through Power BI