cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hlandrus Frequent Visitor
Frequent Visitor

Turn Off Data Export

Is there a way to turn off the new data export feature for a particular data set? There is some sensitive data we have on PowerBI and we want people to have access to reports from this data but we don't want them to be able to download the data. 

 

Thanks, Hanna 

15 REPLIES 15
greggyb New Contributor
New Contributor

Re: Turn Off Data Export

There's no way to disable this in the service presently. You may have more flexibility when embedding visuals in another application using the PBI API.

 

I do have a question, though. Do you intend to block users from printing, screen-shotting, or viewing the reports with a pen and paper in hand?

 

I am not being glib, but very serious. What attack vector are you mitigating by stopping export to Excel? What users do you have who you trust to have access to this sensitive data on demand, on any internet enabled device, but not with the ability to export the very thing on the screen (that they can print or screen cap) into Excel.

 

I understand that security is important, and the fact that exploits still exist doesn't mean you should ignore those you can control, but it seems a bit superfluous to focus on export to Excel functionality in a tool as readily accessible as Power BI. If they can't be trusted with Excel, I don't see why you'd trust them with Power BI in general.

Re: Turn Off Data Export

Diledre Frequent Visitor
Frequent Visitor

Re: Turn Off Data Export

This feature is at the Tenant level, Which would i guess apply for all groups. Is there a feature to restrict export only on selected reports/Dashboards.

Highlighted
bullius Member
Member

Re: Turn Off Data Export

Also, is there a way to allow export of summarized data, but restrict underlying data?

As mentioned above, there would be no point in restricting the export of data that is already on the sceen, but the underlying data shows more than what is on the screen.

bullius Member
Member

Re: Turn Off Data Export

For anyone interested, I managed to disable the export of underlying data by replacing agregates in my table with measures that do the same thing.

 

E.g. I have an "Amount" field in the Values bucket. I wanted the average of "Amount", so instead of selecting Average from the drop-down list, I created a measure that returned the average and put that in the Values bucket.

 

Hope that helps anyone with the same issue!

Re: Turn Off Data Export

ThatchD Frequent Visitor
Frequent Visitor

Re: Turn Off Data Export

The question becomes one of traceability, as well as one of corporate discovery.    Given the potential sensitivity of data being manipulated via the download capability to a device not controlled by a corporate process (ie BYOD) what controls exist to disable the ability to download from the mobile application?

ThatchD Frequent Visitor
Frequent Visitor

Re: Turn Off Data Export

The question is two fold.  First, it's a question of data leakage.  How we map controls to an application are important attestation points.  Second, it's a question of corporate discovery of a personal device (in the BYOD) world.

 

The question is:  for the mobile application, what options are available to differentiate a device using the mobile application that is authorized as a part of corporate device management, vs a non managed personal device to be able to effect download exclussion of the latter?

marceloopus127 Frequent Visitor
Frequent Visitor

Re: Turn Off Data Export

Hi @wynhopkins!

 

Is this a PowerBI Premium exclusive option or is this control available to PRO users?

Thank you!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors