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
gemgorey
Advocate I
Advocate I

Restrict the dataset publishing options...

Hi all!

 

So I don't think this is possible, but thought I would check 🙂

 

I have a golden dataset in its own little golden workspace, all nice and safe.

I have a BA workspace with all my chained datasets and reports that I produce that all update nicely when I refresh my golden dataset.

I am a member of another workspace set up by my business which has everyone in it.  There is one report I still have to publish there that isn't from my golden dataset so I need access.

 

Every day I get the fear that I am publishing the golden dataset to the public workspace.  Every day I check, heart in my mouth.  And thank god I haven't yet!  But, I know it's so easy to do - The dialogue box doesn't really help!

 

What I want is a setting where I can click to restrict the dataset from being published to any other workspace other than the golden workspace. The dialogue box isn't enough - I feel like I need more protection here.  Is there some hidden setting I haven't found?

 

Thanks!

1 ACCEPTED SOLUTION
MAwwad
Super User
Super User

It sounds like you want to restrict the ability to publish your golden dataset to other workspaces. Unfortunately, there is no built-in setting to restrict the publishing of a dataset to specific workspaces in Power BI. One potential solution would be to create a separate user account for publishing the golden dataset, and restrict access to that account to only the necessary individuals. Another option is to use Power BI's Row-level security to limit access to the dataset to only specific users or roles. However, it's important to note that both of these solutions have their own limitations and trade-offs.

View solution in original post

2 REPLIES 2
MAwwad
Super User
Super User

It sounds like you want to restrict the ability to publish your golden dataset to other workspaces. Unfortunately, there is no built-in setting to restrict the publishing of a dataset to specific workspaces in Power BI. One potential solution would be to create a separate user account for publishing the golden dataset, and restrict access to that account to only the necessary individuals. Another option is to use Power BI's Row-level security to limit access to the dataset to only specific users or roles. However, it's important to note that both of these solutions have their own limitations and trade-offs.

Hi and thanks for your response,

 

I didn't think there was a way! I already have roles setup for the dataset but wasn't sure if this would work if I accidentally published it somewhere else. Another user account would work possibly, but I'm constantly in and out of all the files so would need to remember to switch.

 

I'll just have to be careful! 

thanks 🙂

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