Forum Discussion
Workspace Management Best Practices
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?
Many documentations and videos you can find on the internet to answer your first question
7 Replies
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
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?
Many documentations and videos you can find on the internet to answer your first question
I like the way aj1973 explained,
I am in the same scenario and honestly I even thinking where to start because I don't have access to many workspace and the organization allowed everyone to create his/her own workspace and there are a lot of Power BI dev with estimation of more than 100 reports.
Now, I want to start some best practices just for my country so later I can cascade slowly to others because I was using Power BI report server in previous and I managed to hand this now I am new in workspaces.
My question from your solution, if we have one dataset and each of us want to create a report by downloading it so to know the dataset source column will it be possible or it will only need to update the report online.I didn't create a new thread to avoid loosing focus on the best practice you already initiated here.
Hi tmhalila
Not sure to understand your question!
Frist of all, letting everyone in the organization create his/her own workspace not a good practice.
Secondaly, letting everyone in the organization to download the Dataset it is not a good practice.
Thirdly the thin reports should update automatically right after the dataset has been refreshed.
Best Practice is always to leave the dataset in its WS and give Build permission to it but not to the workspace to the concerned users, these users will have to use Power BI Desktop and use the Semantic Model connector to develop thin reports on top of this Dataset.
You have answered my question and the links you have shared they are very helpful and a good point of starting. Thank you!
