How to disable export data in Power BI


Milan Stanojevic
by Milan Stanojevic
Deputy Editor
Loading Comments
Affiliate Disclosure

power bi how to disable export data

There are many cases in which it is necessary to hide sensitive data, such as personal information. For example, a company shouldn’t be able to export the entire employee table, which has contact info, birthdates, and home address.

This is why many users want to know if they can disable export data in Power BI. Yes, that option is available. In this article, we will show you how you can do that.

One user said the following on the official forum:

Is there a way to disable “Export Data” just to a particular report.
I saw many posts in which we can disable int he admin portal. But would that apply to all the reports in the workspace?
1. I would just need this feature for a particular report
2. I dont see any options in Admin portal except Capacity Settings

power bi disable export capacity settings

So, the OP wants to disable Export Data to a certain report, but there are no options for it in the Admin portal.

Steps to disable export data in Power BI

1. Disable export data for individual reports

  1. Click on the Settings button of the report
  2. Choose Export Data to None

New to Power BI? Here’s everything you need to know about it.


2. Disable export data for all reports

  1. In the Admin portal, go to Tenant Settings.
  2. Select Export Data.power bi export data
  3. Disable the feature and click on Apply.power bi disable export data
  4. Alternatively, you can Enable export.
  5. Apply to The entire organization.
  6. Select Except specific security groups checkbox.
  7. Enter security groups for which you want to keep the function disabled.
  8. Click on Apply.
    power bi export enabled except
  9. Also, you can Enable export for a specific group.
  10. Select Specific security groups.
  11. Select Except security groups checkbox.
  12. Write the groups you want to export data to.
  13. Click on Apply.power bi disable export except

It is worth mentioning that it will take up to 10 minutes for a setting change to take effect for everyone.

Conclusion

So, that’s about it. Exporting data is crucial for a dynamic workflow, but sometimes it is necessary to block certain information.

Fortunately, Power BI has this option and as you can see, there are a few easy steps to disable the export of data.

Did you find our methods useful? How do you disable export data in Power BI? Let us know in the comments section below.

RELATED ARTICLES YOU NEED TO CHECK OUT: