Solved: Problem on a project/model

Temainfo-suport · ‎09-13-2022

I Need to build a project on power Bi, the model needs to be like this image, multi databases, all datas has the same data model, each user can't acess others data, i'd like some options if possible, another thing is, how could i identify each database.

Shahfaisal · ‎09-13-2022

Here is how you want to set up your data model:

1. A Company dimension to store company information (company id, company name, etc.).

2. All your fact tables will have a CompanyID to link to the Company dimension I mentioned in #1.

3. You will need a table that shows with user belongs to which company. This table will be used to setup Row LEvel Security. More information on this is here https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Your requirement to restrict users so that they can only see their data is achieved using Row Level Security. Your other requirement to identify each company database is achieved by using the company dimension - for example, if you are looking at Sales, you can use company dimension to break down sales by company, etc.

View solution in original post

Shahfaisal · ‎09-13-2022

Here is how you want to set up your data model:

1. A Company dimension to store company information (company id, company name, etc.).

2. All your fact tables will have a CompanyID to link to the Company dimension I mentioned in #1.

3. You will need a table that shows with user belongs to which company. This table will be used to setup Row LEvel Security. More information on this is here https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Your requirement to restrict users so that they can only see their data is achieved using Row Level Security. Your other requirement to identify each company database is achieved by using the company dimension - for example, if you are looking at Sales, you can use company dimension to break down sales by company, etc.