cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CBO2404
Frequent Visitor

How to organize workspaces with few reusable datasets and high degree of security?

What's the best way to organize workspaces? (Less maintenance and the greatest possible security)

 

I would like to:

  • use one dataset for multiple reports (less maintenance in measures)
  • use a report for multiple groups of users (less maintenance in reportdesign)
  • define security on certain datasets with privacy-sensitive information (such as salary and absenteeism). I don't want employees to be able to access some (e.g. the salary) datasets.
  • have 1 app per group of people

This is the situation I have but the security is not okay. How can I organize this? Which workspaces can I create best with which permission.

 

Example.jpg

 

And how do I hide the dataset menu-option in the Apps environment for endusers?

Apps.jpg

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

- use distribution lists for app access, ideally these lists should be managed by an external access management tool

- use RLS and OLS, but only if absolutely required. Most of the time they are contraproductive

- you cannot hide the datasets from the users that have access to the apps.  "If you don't want them to steal your data, don't show them your data".   Think of it not only from the security perspective but also from the UX perspective.  If you frustrate your users they will seek help elsewhere.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

- use distribution lists for app access, ideally these lists should be managed by an external access management tool

- use RLS and OLS, but only if absolutely required. Most of the time they are contraproductive

- you cannot hide the datasets from the users that have access to the apps.  "If you don't want them to steal your data, don't show them your data".   Think of it not only from the security perspective but also from the UX perspective.  If you frustrate your users they will seek help elsewhere.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors