Skip to main content

Power BI

Needs Votes

Disable export of underlying data

Vote (313) Share
Dan's profile image

Dan on 11 Nov 2017 05:31:44

We are using SSAS Tabular as our datasource and we have issues when users try to 'Export underlying data' from the Power BI Service. The query generated to SSAS when doing this seems to include every measure from the table which in some cases is 30+ measures and sometimes from multiple tables. The query never completes and consumes nearly all resources on the SSAS server.

We need to disable this option while still allowing export of summarized data.

Comments (37)
Dan's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:19:16

RE: Disable export of underlying data

Please disable this element - it is causing our system to hang and clients are getting very frustrated

Dan's profile image Profile Picture

Jim Hillier on 05 Jul 2020 23:17:53

RE: Disable export of underlying data

It does seem a bit odd that users can export the underlying data in Power BI. Please can this be set up in a way that allows us to allow this for some recipients of the reports while blocking others?

Dan's profile image Profile Picture

Ntn2018 on 05 Jul 2020 23:17:01

RE: Disable export of underlying data

It is very important to be able to disable it, as it happens that if the underlying dataset has milion of rows it simply hangs and does not work, and the users ask why.

Dan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:16:46

RE: Disable export of underlying data

In large corporations, users need the ability to control the data exports at the report level (based on named individuals or groups). Most users do not have admin access to the tenants to manage this. We want users to have the self-analytic capabilities and at the same time, ensure that we can provide the correct protection for data when it is warranted.

Dan's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:16:34

RE: Disable export of underlying data

HUGE issue...let us turn off down to the report and/or visual level.

Dan's profile image Profile Picture

Rishi Garg on 05 Jul 2020 23:15:49

RE: Disable export of underlying data

Please suggest when MS is planning to incorporate this feature in near future, and any tentative time lines..

Dan's profile image Profile Picture

Roger on 05 Jul 2020 23:15:39

RE: Disable export of underlying data

Exactly, we need to disable Export underlying data of a panel while still allowing export of summarized data!

Dan's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:14:15

RE: Disable export of underlying data

I would suggest some greater granularity to enable/disable summary & detail exports in the Admin Portal. Additionally separate enable/disable controls for Analyze in Excel

Dan's profile image Profile Picture

Andri on 05 Jul 2020 23:12:29

RE: Disable export of underlying data

this will be a huge help in our dashboard // especially if we share the report externally

Dan's profile image Profile Picture

Raphael Nash on 05 Jul 2020 23:10:48

RE: Disable export of underlying data

We need to be able to secure the underlying data. Some reports summarize highly sensitive data and while I need them to be able to export summaries the underlying data should be hidden. This should also be an option that is controlled report by report and group by froup.