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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors