Workspace Management Best Practices

[datapal04]

Hello, 

I'd like to know some best practices for managing my team's Power BI workspace. Until recently, everyone on my team could publish a PBI report to the workspace. This created a lot of waste as irrelevant reports were published. I've gone through the process of coordinating with team members to remove clutter reports from the workspace, so it's clean now.

To prevent something similar from happening again, I'd like to establish a process for my team that covers report publishing to the team workspace so that all content is relevant, and that each content is tied to atleast one audience. This process needs to be non-cumbersome and should avoid a single individual that gatekeeps/approves which reports belong to the workspace. Any ideas?

[aj1973]

Hi @datapal04 

Best practice is to seperate Reports(Thin Reports) from its Semantic models :

• Create 3 Workspaces: WS_DEV&Test , WS_Dataset_Prod(Could containt only Datssets or both) , WS_Report_Prod (Thin reports
• Use AD security groups to add to WS and share reports in App,
• Members and collaborators can only publish in WS_DEV&Test
• Create App from WS_Report_Prod
• Add reports into different Audiences in App environment
• Add security groups to specific audiences

[datapal04]

Hi @aj1973 , thanks for your reply! What's the reasoning for seperating reports from their semantic models?

I was also thinking that naming conventions can help with determining which reports and semantic models are production-ready (ex. "PROD_Test Report"). What does everyone think of this approach?

[aj1973 · Accepted solution]

Many documentations and videos you can find on the internet to answer your first question

[aj1973]

Hi,

Indeed, naming convention is defenitly a good help. Here is documentations and video for help.

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-workspaces-tenan...

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-workspaces-works...

https://youtu.be/5TVTvThGT8E

To answer your first question :

Separating reports from their semantic models is a best practice in Power BI workspace management. This is because it allows for better control over the data and the reports that are built on top of it. By separating the two, you can ensure that the data is accurate and up-to-date, while also allowing for more flexibility in the creation of reports. Additionally, it makes it easier to manage the different components of your workspace, as you can focus on each one separately. Deleting or removing an Item from a WS by mistake can be very inconvinient because there is no way to restore it, Having the same item in 2 different WS with limit access helps recover it...

Here is some other disadvatanges of not separating items :

https://biinsight.com/thin-reports-what-are-they-and-why-should-i-care-and-how-can-i-create-them/