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
ellisjm
Regular Visitor

Shared Power BI Dataset with Workspace Viewer Role

Hi All! We've got a data set we'd like to publish once to a communal workspace and grant access to our Pro users to use as a source.  However, we don't want them to be able to publish to this same workspace.  They will be able to publish to their my workspace or a team workspace.

I created the communal workspace "Common" and added a few Pro users to test as the Workspace role Viewer.  However, when going into Power BI Desktop, Get Data, and Power BI Data Sets, they could not see the dataset in Common.  When I changed their access to Contributor, they could see the data set.  However, they could also publish to Common.  They should only be able to publish to their own workspace, not "Common".

I also tried going into the service, Common workspace, datasets, manage permissions for the dataset, and changing their permissions here.  Same results, if I changed their access on the dataset from Viewer to Contributor, they could then publish to the whole workspace.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

Whilst I agree that they could publish to the COMMON App Workspace, they would require permissions to access the dataset.

What if you had to share it via an App, and grant them the Build Permissions via the App?
They should then be able to see the dataset as a source and then publish it to their own app?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi there

Whilst I agree that they could publish to the COMMON App Workspace, they would require permissions to access the dataset.

What if you had to share it via an App, and grant them the Build Permissions via the App?
They should then be able to see the dataset as a source and then publish it to their own app?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ Thank you for the help! That worked like a champ.  I removed the access to the workspace for the users, then published an app with the "Allow all users to connect to the app's underlying datasets using the Build permissions".  They can see the datasets from the Power BI Desktop Get Data-Power BI Datas, but can't publish to the workspace.

That is awesome, glad you got it working!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors