Security and build rights

Power BI
1

So with the organisation we need to split access

  • General Access
  • General Access (including secure data)
    Person A will be able to see Costs etc and Person B will only be able to see Sales values and no cost info.

We have done this in the data sets by using measures that multiple cost by 1 if they have access or 0 if they have no access, This works - it is not good but it works.

We need to give a lot of users the right to build reports (composite model) using the datasets. I have checked this and this means that the person with build rights will see the underlying sensitive columns and will be able to create measures without the security. They will see the sales table has a cost column and be able to reference that in a measure.

Is there a way to force the security on people with build permissions or are they just going to see the lot when they get build permissions.
Thanks
E

2

Bumping this post for more visibility.

3

Hi @ells! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum.

However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!