cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmgdotnet Regular Visitor
Regular Visitor

Re: Prevent export underlying data

I have just added this as an idea as I couldn't find it already posted. You can vote here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32213098-disable-export-of-underl...

 

schoolbiguy Frequent Visitor
Frequent Visitor

Re: Prevent export underlying data

Thanks dmg... yeah, this is a pretty big problem for us as well. It is essentially causes us to expose sensitive row-level data that is valuable in aggregate form. It is unfortunate because we really only have two options: 1. prevent all users from exporting data, or 2. remove the aggregate data point that is sensitive at the detail level.

Highlighted
sokatenaj Member
Member

Re: Prevent export underlying data

Yeah, I really need this to be an option. I have to basically duplicate the report to remove these columns. I work in an org where HR can see salaries, but some HR groups can't see salaries even to non-HR staff. So if there is an aggregate they can export underlying data which I cannot afford to happen. 

 

It just seems like standard functionality that should have been available from the start. Please make this happen @Ajay Smiley Happy You guys do such a great job, but I feel this is such a core piece of functionality from an IT security perspective with sensitive data. I voted for it, but there are only 14 votes for the only one I can find. 

Re: Prevent export underlying data

The MDX this generates is crazy, and as noted it consumes nearly all resources on the SSAS server.  To make matters worse, we've seen instances where the query times out after 4 minutes, then the Enterprise Gateway actually re-tries the same query - madness!

 

I'm working for a large Professional Services organisation, with a large and complex Cube with heaps of Measures, and we can't have our SSAS server getting killed for all the Partners and Directors, just because one of our hundreds of users clicked on "export of underlying data", when all they really wanted was covered by "summarized data".  We can't be expected to try and train, and control, the use of this very dangerous MDX query generation, when we have hundreds of casual (but very senior) Power BI users.

 

Additionally, our whole Global organisation is currently one single Tenant, so the admin functions are all controlled Globally.  We need the ability to really fine-tune who can do what, in a large Enterprise that's spread around the world.  At a minimum, please let us:

1) disable Export of Underlying data, ideally with fine granularity of who can and/or can't do it e.g. by AD Group

2) and/or remove it from the product altogether

3) or re-enginner the Export of Underlying data, so it generates good MDX and doesn't just allow users to select Everything in the Table(s) we've used to create a PowerBI Object (usually, a Table visualisation)

 

Personally, I think the "Export of Underlying data" is a flawed idea, I think it's totally inappropriate in a large Enterprise environment, with a large and complex cube.  We don't give all our report users the ability to "SELECT *" from any of our SQL tables, so why ttry and let them do the equivalent on our Cubes?

panoslaz Regular Visitor
Regular Visitor

Re: Prevent export underlying data

Hi I have the same problem, I want to keep the option for the users to download summarised data but not underlying ones. 

 

My main focus is the data tables; I want users to be able to download only the data & fields I have included in the table, not the fields I have excluded 

 

Filters of course work fine 

 

thanks 

panoslaz Regular Visitor
Regular Visitor

Re: Prevent export underlying data

Hey 

I have the same issue 

My main focus is data tables

I want users to be able to export all the fields I have included in the table (i guess that s the summarized data) but not the underlying data. 

 

The underlying data includes many columns I do not want users to have access to 

 

Can you please let me know how you solved that?

 

thanks in advance 

Panos 

panoslaz Regular Visitor
Regular Visitor

Re: Prevent export underlying data

Hey 

I have the same issue 

My main focus is data tables

I want users to be able to export all the fields I have included in the table (i guess that s the summarized data) but not the underlying data. 

 

The underlying data includes many columns I do not want users to have access to 

 

Can you please let me know how you solved that?

 

thanks in advance 

Panos 

SirGalatsi Member
Member

Re: Prevent export underlying data

@panoslaz, if you have a a pie chart visual a matrix visual with a sum, total, avg, etc. you can turn off visual headers for those visuals. In August, Microsoft introduced the ability to turn off headers for each visual so that you can't export or put things in focus mode. This is a good way to block that from happening. If you have a table visual with no sum in the columns, you can keep the visual header on because it won't give you the option to export underyling data anyways. You'll see the headers when developing in Desktop, but otherwise when published they will disappear. This has helped me a ton! 

 

Hope this helps re. Smiley Happy 

 

-Aris

panoslaz Regular Visitor
Regular Visitor

Re: Prevent export underlying data

Hi

Thanks a lot

that s interesting but I still have the same issue. 

 

I have disabled the sums from my tables but I still get the option of underlying data. I am using simple tables (not matrices)

 

I am accessing the report as a user and I can download the full dataset from the underlying data option, which is something I need to restrict other users from doing 

 

Do you have any idea how i could fix that?

thanks 

 

 

 

stt11 Frequent Visitor
Frequent Visitor

Re: Prevent export underlying data

Can you explain what your solution was? I am running into a similiar problem.