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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors