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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
akj2784
Post Partisan
Post Partisan

Workspace Setup recommendation in Service

Hi All,

 

We are trying to setup workspace and wanted to know your recommendation.

 

Do you suggest creating 

 

Approach 1:

Dev, QA and Prod workspace and publish the contents on each depending on where we want to publish. So if we are in development phase we can publish it to Dev Workspace and once we want to open it for QA testing, we can publish the same to QA Workspace. And similarly for Prod.

 

OR

Approach 2:

Create workpace for various data categories like

for HR, we create HR Dev, HR Qa and HR Prod

For Marketting team, we create Marketting Dev, Qa and Prod

and so on.

 

You can suggest any other approach if you have.

 

Regards,

Akash

5 REPLIES 5
Greg_Deckler
Super User
Super User

That really depends on your security considerations, does it matter if HR people see all of the dashboards/reports? If so, then use the second approach, otherwise I always believe that simpler is better.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Yes we don't want HR people to see other dashboards. But can't we control the access at individual dataset and dashboard level even if we have everything on Dev workspace ?

 

I just want to understand best practice followed in other real time projects.

While you could, again, going back to simplicity, I would do it by workspace.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

So you suggest approach 2. But will not end up having too many workspace if we have various BUs like HR, Finance, Marketing, Consulting etc..

Also how do we deploy the code from one workspace to other. Lets say we develop something on HR Dev Workspace. Now I want the infrastructure admins to deploy the code from Dev workspace to Prod workspace.

That all depends on how you are doing your development. If you are using Desktop and then Publishing, you would just publish to a different workspace.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.