Semantic Model Best Practices

[gdps_vc]

Greetings!

I have a semantic model, called “Active Employees”, with two tables:
> Employees_db - with several information about employees (name, position, salary, address, etc...).
> dCalendar - a calendar table

I need to create 3 reports with the information from “Active Employees” - basically there will be 3 tables so the business can extract the information.

> Employees Full - with all the information from Employees_db
> Employees Intermediate - information from Employees_db, except salary and derivatives
> Employees Basic - basic information such as name, position, manager

Important: an employee who accesses Employees Basic should in theory not access Employees Intermediate or Employees Full.

What should be the best practice for creating these reports?

In the Active Employees model, should I copy (reference) Employees_db 2 times. And use each table separately for each report?

Or should I just use Employees_db as the data source for the 3 reports, selecting the columns that should appear in the table visual?

Or is there a more recommended method? And how would I deal with RLS in these cases?

Best Regards

[Anonymous]

Hi, @gdps_vc 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[djurecicK2]

Hi @gdps_vc ,

 I would suggest doing what you've said below. Do not copy the Employees_db table.

Or should I just use Employees_db as the data source for the 3 reports, selecting the columns that should appear in the table visual?

Here is more information about row level security:

https://learn.microsoft.com/en-us/training/modules/row-level-security-power-bi/