How can we improve Power BI?

Disable export of underlying data

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.

302 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Dan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

38 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Dan commented  ·   ·  Flag as inappropriate

    It seems the feature to disable this on a per-report basis has been removed. Please bring this feature back as soon as possible.

  • Anonymous commented  ·   ·  Flag as inappropriate

    It Looks like "Test as Role" on the service doesn't actually work correctly for testing RLS on exporting data. It lets me download all the data, however when I had the actual user try downloading, they only got the rows they were supposed to get. (I did hide all the tables though after reading through the comments). So there's a bug with the "Test as Role" in emulating what happens with the Export Data feature.

  • Dan commented  ·   ·  Flag as inappropriate

    It's been pointed out there is a new (?) feature for disabling the ability to export underlying data which is configurable on each report. If you go to the report list in Power BI Service, click the gear icon, the last setting is to control what type of data can be exported.

    It would be great if this was a tenant wide setting as we have hundreds of reports to configure this option on and we need to remind our report authors to configure this on new reports however this is a good first step to get this under control.

  • Ani2705 commented  ·   ·  Flag as inappropriate

    Please remove the ability to extract underlying data, but maintain the possibility to export summarized data!
    It's a huge problem in our business and I'm pretty chocked that this problem has been here for so long and it's not yet solved... :-(

  • Topher60657 commented  ·   ·  Flag as inappropriate

    While the 9/5/2018 solution may work, it means that you have to do all your content creation in the desktop application. You are not able to build your content in the Power BI service. I am not able to unhide/rehide tables in the Power BI service as I create content. As Tennant admins we need the ability to disable the export underlying data feature in the Power BI service.

  • Eleonora commented  ·   ·  Flag as inappropriate

    The last comment from "Anonymous" (on 9/5) works. By hiding the tables in the model you can prevent people from downloading underlying data.

  • Anonymous commented  ·   ·  Flag as inappropriate

    A way around this I have found is to set all tables and columns in the data model to "Hide". This stops any underlying data being exported

  • Anonymous commented  ·   ·  Flag as inappropriate

    This functionality needs to be enabled asap. We have switched off the export function for most of our users as they would be able to see the underlying data (some of which is sensitive).

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please prevent exporting underlying data!!! That is the biggest problem in Power BI.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Also, one should have an option of disabling download by user groups and reports. Plus this option should be with person who is sharing those reports.

  • Mez commented  ·   ·  Flag as inappropriate

    The situation is getting desperate due to this issue. We have executives constantly coming across this problem (either due to attempting to export or some other user attempting to export and killing the responsiveness from the server) making the software an embarrassment for us.

  • Charles Higby commented  ·   ·  Flag as inappropriate

    This is the single largest issue with using PowerBI in a multi tenant environment. Could we please get an update from the PowerBI team when this will be resolved? Allowing administrators to turn on export summary data whilst turning off export for all underlying data is a setting we have been crying out for. Given the security implications one would hope it is a high priority feature scheduled for an upcoming release soon.

  • Matt Meddings commented  ·   ·  Flag as inappropriate

    Another person crying out for this... It seems crazy we can lock-down a report with RLS only to have the security model destroyed by anyone with just a few clicks.

    It should be a report-level option to allow export of underlying data, not tenant-wide.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We have a Simlar Requirement. We would like some daskboards to have this feaure and others not. We have sensible data that is presented to certain organizational Departments and need to share the dashboard to everyone at aggregated level, nevertheless do not want to have everyone downlaod the raw data as that will give detailed underlining data access to everyone!

  • Dan commented  ·   ·  Flag as inappropriate

    This is a continual headache for us and is causing huge problems, can we get some input from the Power BI team on this one?

  • Anonymous commented  ·   ·  Flag as inappropriate

    So critical, PLEASE can this get worked on. We cannot offer the end users access to lowest level of detail, not to mention the strain on the servers.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.