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

Export Data from Visual without Build Permissions

Hello Data Savvy people! I was hoping you could help or confirm my concerns on the below situation...

With the recent Power BI Desktop and Service updates it looks like we now have access to Shared and Certified Datasets which looks to have brought over new security privisioning in the service. I noticed all previously shared reports now have "Read, Build" permissions granted automatically to their datasets. Immediatly I disabled the new Shared Dataset feature and remove the build permissions on all of my datasets so I could vette what should and should not be shared. Interestingly enough, it was noticed that a previous report, one which users export summary data from, no longer worked in that regard. I found that the EXPORT DATA from a visualization's More Options(...) feature looks to be tied to this BUILD permission on the dataset. I bring this up becuase in some cases sharing SUMMARIZED data is fine for my customers but sharing with them the underlining data may NOT be ok. Now, if I wanted to turn on the Shared & Certified dataset feature these users would have access to start Power BI reports of their own from this dataset and potentially see sensitive information before aggregations. 

 

Is there a way to go about setting this up to allow for the exporting of summary data from a report visualization without granting users build permissions on a dataset, basiaclly allowing them to start new reports and see underlying data? 

 

Thanks! 

13 REPLIES 13
Community Support Team
Community Support Team

Re: Export Data from Visual without Build Permissions

Hi @5altwaterCowboy 

You could put the dataset in an App workspace, create reports/dashboards here, then publish the finished apps to large groups of people in your organization.

 

In this way, users can see the reports, export summary data from a report visualization, make a copy of reports in this app to their My workspace, then create their own reports based on the dataset.

 

Please read through this link:

Publish an app in Power BI

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5altwaterCowboy Frequent Visitor
Frequent Visitor

Re: Export Data from Visual without Build Permissions

@v-juanli-msft ,

 

Thank you for the suggestion to implement Apps as an additional layer but this still does not solve my security concern. I am able to share through an App but the Export Data Option for a visual still requires the BUILD permissions assigned to the user on the datset to work. If I have this permission granted and the tenant setting "Use datasets across Workspaces" enabled then the user could simply start a new Power BI report in Power BI Desktop source this dataset and see the underlying data.

 

Why does the report allow us to specify the export of summery OR export of underlying data if this new "Use datasets across workspaces" feature is just going to circumvent that by allowing users to pull the datasets into Power BI desktop regardless. 

 

Thanks! 

Community Support Team
Community Support Team

Re: Export Data from Visual without Build Permissions

Hi @5altwaterCowboy 

It seems you create an new App workspace.

What i refer to is classic App workspace.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5altwaterCowboy Frequent Visitor
Frequent Visitor

Re: Export Data from Visual without Build Permissions

@v-juanli-msft ,

 

So what you are saying is that in the NEW Workspace Experience what I have experienced with the Security is the expected result. However, if I were to create a classic workspace this would be mitigated by working as designed prior to this update? 

 

Thanks! 

chaz2jerry Regular Visitor
Regular Visitor

Re: Export Data from Visual without Build Permissions

I have same concern and challenge with the OP, that the current setup of Build Permission is too extensive and need to find a middle ground in terms of data access permission.  What I (and I assume others) need is a middle configuration where users cannot build new reports on the dataset, cannot use Analyze-in-Excel function (same as building new reports), but can still use Export to Excel based on pre-configuered visuals.  This way the developer can control what data granularity is available to the consumers.  

 

This ties in to existing requests to disable Analyze-in-Excel feature specifically, and now expands into the broader scenario of Build Permission and shared datasets.  

Highlighted
braypa Frequent Visitor
Frequent Visitor

Re: Export Data from Visual without Build Permissions

I concur that the build permissions is too extensive. There needs to be an option to allow users to read and export to Excel, without giving them permission to build their own reports.

TobiasOwen Member
Member

Re: Export Data from Visual without Build Permissions

Yes, exactly this. I would like "Export to Excel" treated separately from "Build" permission, because "Build" raises massive security concerns whereas "Export" is easy to control.

gelliott02 Regular Visitor
Regular Visitor

Re: Export Data from Visual without Build Permissions

Who signed off on having build permissions as a requirement for exporting data? Now in order for someone to have a basic functionality that has been there since launch (exporting) we only need to grant them access to the entire dataset. That defeats the entire point of sharing a report and not a dataset. Well done MS. 

AnalystPete Occasional Visitor
Occasional Visitor

Re: Export Data from Visual without Build Permissions

Agree, it's surprising that this is an all or nothing setting and that it includes export to excel.  

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 250 members 2,828 guests
Please welcome our newest community members: