Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Sharing dataset for PBI reporting

Hi All,

Is there a way that we can provide dataset access to the power users of the organization for building a PBI report, without letting them to modify the original data set, however they can make a report on the data set and export to personal workspace.

What would be the best way to full fill this scenario.

Regards,
Manveer Nakoti

1 ACCEPTED SOLUTION
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @Anonymous 

What you want is to grant your report users "Build Rights". There are several way to do this. When you share a Report, select the option "Allow recipients to build content with the data associated with the Report".

Burningsuit_0-1664794006654.png

Or , if you share an App, select the same option in the Advanced settings for the Audione (In the new app UI)

Burningsuit_1-1664794172810.png

Or the "Build permissions" option in the old App UI

Burningsuit_2-1664794245620.png

Furthermore you can grant Build permissions individually on a Dataset, go to "Manage Permissions" on the Dataset, and add "Build" permissions on an individual basis.

Burningsuit_3-1664794431458.png

"Build" permissions allow the Report consumer to create new Reports based on the Data in the Dataset, or to use "Analyse in Excel" to access the Data in the Dataset. If the users do not have any other permissions, i.e. they are not "Members, Contributors or Admin" in the Workspace they will be subject to Row Level Security if it is applied to the Dataset.

The users will find the Dataset by going to the "Data Hub" from their Power BI home screen, there they are shown Dataset that they have access to or can request access to.

Burningsuit_4-1664794711854.png

Hope this helps

Stuart

 

View solution in original post

2 REPLIES 2
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @Anonymous 

What you want is to grant your report users "Build Rights". There are several way to do this. When you share a Report, select the option "Allow recipients to build content with the data associated with the Report".

Burningsuit_0-1664794006654.png

Or , if you share an App, select the same option in the Advanced settings for the Audione (In the new app UI)

Burningsuit_1-1664794172810.png

Or the "Build permissions" option in the old App UI

Burningsuit_2-1664794245620.png

Furthermore you can grant Build permissions individually on a Dataset, go to "Manage Permissions" on the Dataset, and add "Build" permissions on an individual basis.

Burningsuit_3-1664794431458.png

"Build" permissions allow the Report consumer to create new Reports based on the Data in the Dataset, or to use "Analyse in Excel" to access the Data in the Dataset. If the users do not have any other permissions, i.e. they are not "Members, Contributors or Admin" in the Workspace they will be subject to Row Level Security if it is applied to the Dataset.

The users will find the Dataset by going to the "Data Hub" from their Power BI home screen, there they are shown Dataset that they have access to or can request access to.

Burningsuit_4-1664794711854.png

Hope this helps

Stuart

 

Anonymous
Not applicable

Thank you It is very well documented

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!