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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Allow users to connect to PBI dataset in Excel without allowing edit rights to Service workspace

Hi all,

I need to allow users to connect to my Power BI datasets via Excel, but would like to avoid giving workspace access/edit rights to everyone, where they could directly affect content and reports.

 

Is there a middle ground between viewing and total report/dataset control? It seems to be not ideal that anyone who can play with your data can also delete/edit/etc. all your reports.

1 ACCEPTED SOLUTION
cassidy
Power Participant
Power Participant

Giving build permissions to the Dataset can be separate from edit rights in the Workspace.

 

Manage Permissions on the Dataset to allow Build, but set the users right for the Workspace to Viewer.  Or, even better in my opinion, keep your Datasets in a seperate Workspace with no access to Users, with Reports in a viewable Workspace.

View solution in original post

2 REPLIES 2
cassidy
Power Participant
Power Participant

Giving build permissions to the Dataset can be separate from edit rights in the Workspace.

 

Manage Permissions on the Dataset to allow Build, but set the users right for the Workspace to Viewer.  Or, even better in my opinion, keep your Datasets in a seperate Workspace with no access to Users, with Reports in a viewable Workspace.

Anonymous
Not applicable

That did it, thanks. Wasn't aware that you could add permissions at a dataset level.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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